Can you use the same measure twice?
I'm sure I've seen this feature but i cant remember where so. Is it possible to to use the same measure and 2 filters to display different figures on the same axis of a graph.
For example if i wanted to use the measure "products dispatched" but had to build 2 custom lists 1 for day shift workers and 1 for night shift workers can it be displayed like this? see photo.
Many thanks
2 replies
-
Hi Ali Trotter
Seems straightforward.
Select a column chart.
Have the measure in the 'Value' dropzone.
Your days in the 'Categories' dropzone.
And the hierarchy with the two calculations for Night/Day shifts in the 'Color' dropzone.
Run the query.
I used deferent hierarchies, but it looks the same as what you are asking for.
Kind Regards,
Yakov -
Worked Perfectly, i was trying to use a standard list, switched to an aggregate and it worked perfectly.
Many thanks
Ali