Can I build a query with a parameter that is editable on the dashboard?

Reply
Highlighted
White Belt

Can I build a query with a parameter that is editable on the dashboard?

I have a query:

 

select * from function_get_data(date)

 

I see there is a query parameter option, but how can I allow the user to modify this on the front end? 

 

Thanks!

Highlighted
Red Belt

Re: Can I build a query with a parameter that is editable on the dashboard?

hey @user053351 ,  you can use FUSIONS + Webforms to create parameterized queries.

 

check out this video for an example.

https://www.youtube.com/watch?v=wmMrnPO9ivY&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=7&t=59s


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
NoETL strikes back! Jae Wilson shares how to build an accounts receivables aging report with parameterized date values. #Fusion #Domo
Highlighted
White Belt

Re: Can I build a query with a parameter that is editable on the dashboard?

The video explains using a dynamic parameter on an existing data set. This doesn't impact the data that is inside the set. I need that date parameter to be changable from the front end. 

 

I don't understand Domo very well, is all data pulled into the tool? Are there live connections with Domo?

Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.