Is it possible to have the options for my filter control come from a different data source? I have a large data set and I want to display only the selected values but I don't want to pull from that whole data source to get those options, if that makes sense
Hey David, Thanks for explaining each steps in details with deployment and showing the results. The getData session is little confusing and I hope you could have cover this in more detail. Nevertheless, an awesome tutorial.
Hi Ketan! Glad it was helpful! Yes, the getData() function is probably the most complex out of them all and how you write it is also highly dependent on where you're sourcing the data from in the first place. But have no fear! The most important thing to remember is that every GetDataResponse Object needs to include data and the fields associated with that data. As long as you have those two things, you can write whatever code you need to source and return the requested data to your user in Data Studio. If you have any further question feel free to add them to this thread :)
@@DavidWeissProgramming Can you do a piece on getting data from Google Sheets Programmatically? This way, on function execution, Data Studio data is always fresh (while not having to fire every minute)
Hi David, do you know how to set the grid color in the javascript file? i have configured my json to display the choice of the grid but i dont know how to set it. For example the height we set it this way svg.setAttribute("height", `${height}px`); what about the grid? thanks
Great explanation, David!
Is it possible to have the options for my filter control come from a different data source? I have a large data set and I want to display only the selected values but I don't want to pull from that whole data source to get those options, if that makes sense
Hey David, Thanks for explaining each steps in details with deployment and showing the results. The getData session is little confusing and I hope you could have cover this in more detail. Nevertheless, an awesome tutorial.
Hi Ketan! Glad it was helpful! Yes, the getData() function is probably the most complex out of them all and how you write it is also highly dependent on where you're sourcing the data from in the first place. But have no fear! The most important thing to remember is that every GetDataResponse Object needs to include data and the fields associated with that data. As long as you have those two things, you can write whatever code you need to source and return the requested data to your user in Data Studio. If you have any further question feel free to add them to this thread :)
@@DavidWeissProgramming - That's awesome. Thanks.
@@DavidWeissProgramming Can you do a piece on getting data from Google Sheets Programmatically?
This way, on function execution, Data Studio data is always fresh (while not having to fire every minute)
Hi David, do you know how to set the grid color in the javascript file? i have configured my json to display the choice of the grid but i dont know how to set it.
For example the height we set it this way svg.setAttribute("height", `${height}px`);
what about the grid? thanks
Thank u so much :)
You're welcome!
hey sir can we have contact i have some question how i can contact you