I have a BAQ with parameters so people can pick a date range. None of the parameters are required and they work in the BAQ. When I create a dashboard, the parameters pop up but nothing happens when you enter dates. No data is returned. The Job filter works and is set to not be mandatory. Any ideas why it’s not working?
Can you include a screenshot of the filters on the baq? It’s possible it is returning null values and there aren’t any. I’m assuming when you test the BAQ, you can run it ‘open’ without parameters?
1 Like
Could you instead put your parameters in the Tracker and have it Honor Nulls so that the date range is required?
You’d remove the parameters from your BAQ and add the date fields for the Tracker…
1 Like
I typically find it more effective to use the parameters on the tracker level instead of the BAQ level.
2 Likes
Ms. Mellissa: Are you testing your parameters from either a dashboard deploy Test or fully deployed dahsboard?
I have seen where BAQ parameters were ignored when run from the dashboard developer. testing the dashboard from deploy test fixed the issue for me (at least that was a few iterations ago).
DaveO
2 Likes
I know that this isn’t really the question you asked, but I’m gonna throw this out there anyways.
I’m assuming that you are using parameters for the date ranges because you are trying to apply 2 filters to one field? (a greater than or equal to, and a less than or equal to). If that’s not the case, and you are using parameters for some other reason, you can disregard.
I would proposed that instead of doing that, skip the parameters. To make a date range selection, first, create a calculated field that is simply the original date field. So now you have 2 columns with the same dates in them. Then in your dashbaord, only show the original date field, but in the dashboard trackers have one filter ( >= ) on the original field, and a second filter on ( <= ) on the calculated field. The user won’t see a difference and then you don’t have to play around with the parameter pop up and you can get 2 filters on the date to get an effective date range filter.
4 Likes
Thank you!! That was what I was trying to do but didn’t quite understand the instructions in other posts. Duplicating the field worked!!
2 Likes