The formula below takes the Max Count + Min Count / 2 to come up with a centered axis which shows where the data falls from the median.
What i'm trying to do is get the line to align with the average which is determined by the field [Shipped Dec 2017] ...
Or get the center to become the 4 and roll the axis down.
Workbook attached. thanks!
My problem was the 2nd half of the calculation.
I created two separate calcs:
- Business Days (Current Month)
- Days Remaining
The difference between those returns how many days we've been through.
I replaced the divisor by that number and it adjusted my axis lines accordingly.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...