If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Elegant Way to filter # of x-axis values in chart

Started by tschuman13, 14 Mar 2014 01:18:35 PM

Previous topic - Next topic

tschuman13

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.

MFGF

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.
Meep!

tschuman13

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?