COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => RAVE Visualizations => Topic started by: paju91 on 24 Apr 2014 08:49:41 AM

Title: Make RAVE line chart scale change on filter
Post by: paju91 on 24 Apr 2014 08:49:41 AM
Hey everyone,

I'm currently developing an active report using RAVE visualizations. The report uses a line chart to display the history of values in the last months. I change the data displayed in that chart by interactively filtering it. The problem is that the range of data shown in that graph reaches from 1 to over 500.000. When the visualization is initially drawn, it uses the largest value to label the axis. When I change the filter in order to display smaller values, tha labes on the axis don't make any sense since you cant see the difference between 200 and 300 on a scale of 100.000 per unit. Is there any possibility to dynamically change the scale or make the enginge reload the scale for the current values?

I know I could solve this problem by using a data deck but since I'm using over 700 different combination that won't work.

The line chart can be found at https://www.analyticszone.com/homepage/web/displayMarketplacePage.action#catalog/viz_assets_line_marked (https://www.analyticszone.com/homepage/web/displayMarketplacePage.action#catalog/viz_assets_line_marked)

I hope you can help me!

Thank you!

Greetings

paju
Title: Re: Make RAVE line chart scale change on filter
Post by: MFGF on 24 Apr 2014 09:14:52 AM
Quote from: paju91 on 24 Apr 2014 08:49:41 AM
Hey everyone,

I'm currently developing an active report using RAVE visualizations. The report uses a line chart to display the history of values in the last months. I change the data displayed in that chart by interactively filtering it. The problem is that the range of data shown in that graph reaches from 1 to over 500.000. When the visualization is initially drawn, it uses the largest value to label the axis. When I change the filter in order to display smaller values, tha labes on the axis don't make any sense since you cant see the difference between 200 and 300 on a scale of 100.000 per unit. Is there any possibility to dynamically change the scale or make the enginge reload the scale for the current values?

I know I could solve this problem by using a data deck but since I'm using over 700 different combination that won't work.

The line chart can be found at https://www.analyticszone.com/homepage/web/displayMarketplacePage.action#catalog/viz_assets_line_marked (https://www.analyticszone.com/homepage/web/displayMarketplacePage.action#catalog/viz_assets_line_marked)

I hope you can help me!

Thank you!

Greetings

paju

Hi,

Hopefully all you need to do is to select the measure value in your visualization, go to its Value Range property, and choose the "Filtered data" option.

Cheers!

MF.
Title: Re: Make RAVE line chart scale change on filter
Post by: paju91 on 24 Apr 2014 12:59:33 PM
Hey MF,

thank you very much. I somehow overlooked this option.

paju