Dual axis chart showing two slices of the same metric
3 January, 2013
Hello, please can you help me create a dual axis chart like the one in the attached image? I would like to visualise the performance of a single club against the performance of all other clubs.
I have had multiple attempts at this using a report with a union sub query. The main report had a filter using 'different from one club' and the sub query report had a filter using 'equal to one club'. I have tried a cross tab report then tried using this with a combination chart using a dual axis. I can create the dual axis, but cannot see both series.
Am I able to produce a chart where 2 slices of the same metric are used? I am using version 6.1 and downloaded the latest patch from the 21st of December 2012 before attempting this chart.
Any help would be very gratefully received.
Thanks and Best Regards,
Steve Chapman
DSCallards Limited
Yellowfin UK Partner
I have had multiple attempts at this using a report with a union sub query. The main report had a filter using 'different from one club' and the sub query report had a filter using 'equal to one club'. I have tried a cross tab report then tried using this with a combination chart using a dual axis. I can create the dual axis, but cannot see both series.
Am I able to produce a chart where 2 slices of the same metric are used? I am using version 6.1 and downloaded the latest patch from the 21st of December 2012 before attempting this chart.
Any help would be very gratefully received.
Thanks and Best Regards,
Steve Chapman
DSCallards Limited
Yellowfin UK Partner
Hi Steve,
To do what you after, you should only need to create an Append sub-query.
So you want to compare regions across a time period.
In the master query just return the date dimension, and metric.
Then add a filter for your club.
In the sub-query add the date dimension, metric and filter for all other clubs.
You can then create a normal line chart and display both lines, renaming the columns so that it's easy to read.
E.g.
(in my example I have added the athlete region field to help illustrate the master query fields)
Filter setup:
Then once you add your chart and rename the columns you will end up with this:
Please let me know if run into any problems with this.
Regards,
David
To do what you after, you should only need to create an Append sub-query.
So you want to compare regions across a time period.
In the master query just return the date dimension, and metric.
Then add a filter for your club.
In the sub-query add the date dimension, metric and filter for all other clubs.
You can then create a normal line chart and display both lines, renaming the columns so that it's easy to read.
E.g.
(in my example I have added the athlete region field to help illustrate the master query fields)
Filter setup:
Then once you add your chart and rename the columns you will end up with this:
Please let me know if run into any problems with this.
Regards,
David
Hi David
Thanks. We have now got the chart displaying both values and with dual axis.
We have three filters (user prompts) - club (equivalent of region in your example), date range, and gender. It is quite cumbersome having to prompt twice for each (once for each query, so six in all).
Is there a way to prompt the user once for each filter rather than twice, and feed the selected values through to both queries? Specifically with the club / region prompt it would need to feed the value through as 'equal to' to one query and 'does not contain' to the other.
Thanks
Angus
Thanks. We have now got the chart displaying both values and with dual axis.
We have three filters (user prompts) - club (equivalent of region in your example), date range, and gender. It is quite cumbersome having to prompt twice for each (once for each query, so six in all).
Is there a way to prompt the user once for each filter rather than twice, and feed the selected values through to both queries? Specifically with the club / region prompt it would need to feed the value through as 'equal to' to one query and 'does not contain' to the other.
Thanks
Angus
Hi Angus,
Glad you have it working.
If you have filters in both queries that will be using the same filter values,
you can simply use the 'link to filter' option (on the filter setup page).
It means only 1 filter is displayed and the value will be passed to both.
e.g.
Please keep in mind, this will only work if you want the same value to be passed to both queries.
Regards,
David
Glad you have it working.
If you have filters in both queries that will be using the same filter values,
you can simply use the 'link to filter' option (on the filter setup page).
It means only 1 filter is displayed and the value will be passed to both.
e.g.
Please keep in mind, this will only work if you want the same value to be passed to both queries.
Regards,
David