1

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

null
    • Yakov_Shaul
    • 4 yrs ago
    • Answer
    • Reported - view

    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

    • Ali_Trotter
    • 4 yrs ago
    • Reported - view

    Worked Perfectly, i was trying to use a standard list, switched to an aggregate and it worked perfectly.

     

    Many thanks

     

    Ali

Login to reply

Content aside

  • Status Answered
  • 1 Likes
  • 4 yrs agoLast active
  • 2Replies
  • 33Views
  • 3 Following