I am new to tableau and stuck at this,
There are 5 segments and each segment has many stores. The aim is to calculate the ratio for a particular store and compare it with the ratio of all the stores in the segment the store is in.
Filter - Store
The assets are lined up for a particular store.
Ratio is the count of all CM/PM YTD for the store chosen. This is the % of work orders shown on the main page.
Segment is the count of all CM/PM YTD for the segment the store in. This is the % of work orders shown on the main page.
Below is how I calculated Store Ratio:
Created 3 calculated fields for Counting work orders of CM, PM and one for the Ratio (CM/PM)
So store ratio is done.
Stuck with segment ratio.
Can anyone please guide me how to achieve this?
Attached is my requirement.
Sorry for the long text. Thank you for your time.