I have a report that works great as-is. A radio button allows users to look at data daily, weekly, monthly, quarterly, and yearly trends of data. The radio buttons are tied to a deck with one card for each radio button value. I use a different query item for each category/x-axis value in the chart and all cards use the same query.
A new request has come in to limit the number of days, weeks, months, etc. So only show the last 30 days, only show the last 12 weeks, 13 months, etc. Is there anyway to do this in one query in AR? In the past, non-AR reports, I would reference the ?PROMPT? value to see which filter to apply to the data to limit the number of days. I don't believe there is a way to reference the AR variable in the query so I thought I would check here to see if anyone had any ideas, before I go ahead and create a separate query for each time frame.
Thanks in advance for any help.
Hi,
This is rather tricky if you are using charts since charts cannot be filtered interactively in the rendered MHT output. If you are on 10.2.1 or later you might try this with visualizations instead, which you can filter. You could perhaps add query items calculations for each scenario, eg the 30 days item might be
if ([your_date] between _add_days(current_date, -30) and current_date) then ('Last 30 Days') else (null)
etc
You could then add these items as extra category values to your visualization and filter on them from a control.
Just a thought,
MF.
Thanks for the response. I was attempting something alone those lines but how do I access the AR variable control in my query? Is there anyway to get the value selected in my query?