I could really use some help with calculating the below requirement:
Interested in the calculation the Avg of all past MTD in the current year. Basically looking to measure how does our regional sales team are performing so far month in
comparison to the MTD avg of that region. I know how to calculate previous month MTD - but again, interested in the current year monthly avg.
Tomorrow is Nov 2nd 18 ==> MTD = 500
looking to get the Avg of past months for the first 2 days of the month.
Hugely appreciate any help here!
This sounds like a calculation to be done with a Level of Detail calculation. Would you have a packaged workbook with sample data to share with the community to show what you have tried and where you are stuck?
Packaged workbooks: when, why, how
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...