Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: saumil287 on 22 Mar 2011 12:05:42 AM

Title: Guage
Post by: saumil287 on 22 Mar 2011 12:05:42 AM
Hi All,
How to create a guage chart which shows data only for top 10 customers.
Title: Re: Guage
Post by: rajatrastogi on 23 Mar 2011 06:12:06 AM
Hi,

1. Create a Gauge chart to show data for all customers.
2. Add a query calculation 'Rank' with definition as rank(<Your Measure>)
3. Add a filter in same query as 'Rank'<=10
4. You will get gauge chart for top 10 customers based on your measures

Regards,
Rajat Rastogi
Text only | Text with Images