Hello,
I have a BAQ that uses a parameter that works great.
I created a dashboard to use it. After selecting the parameter, how do I get it to show the value in the dashboard?
Sometimes I run a dashboard and then get called off. When I come back, I don’t remember that value of the parameter selected.
Any help is appreciated.
Thanks,
Shawn
Hi @shobdy, I am not sure I understand your question. So after you enter in your criteria (in the dashboard’s tracker panel) and hit the refresh icon, does data from the 1st record populate the criteria fields in the tracker? If so, then that is simply needing to set the checkbox for “Input Prompts Only” set to true in the tracker properties?
Hello @DGodfrey,
The parameter screen pops up when you refresh the dashboard.
You put in your date and hit OK.
It then fills in the data in the dashboard.
The parameter input you just put in doesn’t show anywhere on the screen since you fill it in the pop-up.
Does that make sense?
Hmmm…
I was sure I’d done this via a calculated field in BAQs before - using the parameter list
However, it does not seem to be working when I just checked
But I’m on an older system right now - possible depends on version E10 or SQL?
No need for the Param in the BAQ if you add a tracker panel and set the field your Param uses to be an input.
If the Param field will need to be a displayed column of the BAQ. But the dashboard doesn’t need to show it in the grid display.
I needed the date to be a filter in the baq itself instead of filtering the completed baq.
It looks like it is passing the parameter as a calculated field now.
Now I just need to get that to fill in a epiText box…
If I get stuck on that, I will post in here.
If it works, I will mark your post as the answer.
Thanks!
Shawn
From what I’ve been told, the Filters applied to a BAQ in a dashboard, are applied during the SQL execution. Anything that is filtered out is done so at BAQ execution, not to the data returned by the BAQ.
Obviously, you’d not want to use the “Refresh on load” function, else the initial data set would ignore the tracker input (as it’s not yet been set by the user).
I needed the date filtered in a subquery to run to filter the main query. When I tried filtering using a tracker that it didn’t calculate the BAQ correctly. Once I switched it into a parameter, it started working fine.
I did get the date to show in a customization on my dashboard so I am going to mark the post complete.
Thank you for your help, it is appreciated.
Thanks,
Shawn
A little late, but I’ve just made a calculated field that is only @parameter. Then hide that in the grid, but you can show in your tracker without prompting.