Hello Tableau Community!
Tableau beginner here, and enjoying learning the tool and its capabilities.
I'm trying to come up with an average over period selections however not sure how to deal with it.
The report comes out okay on individual months however becomes off on increased number of periods.
Periods are in text form (how all four data sources are glued to each other)
Attached are pictures for Periods:
201301 and 201302 combined
Total Headcount: 45
Net Sales: $5,458,563
Sales per HC: $121,301
Total Headcount: 46
Net Sales: $6,610,378
Sales per HC: $143,704
201301 and 201302 per current calc
Total Headcount: 91
Net Sales: $12,068,940
Sales per HC: $132,626
201301 and 201302 target
Total Headcount: 46 (45.50 average)
Net Sales: $12,068,940 (total)
Sales per HC: $132,503 (average per hc)
Appreciate all the help.
Victor, Welcome to the community and Tableau!
How is your [Sales per HC] calculation defined? From your example, looks like it may be couting the number of employees twice. The aggregation might be the issue.
Are you using a SUM when you want to use an AVG? Or, perhaps, are you using a COUNT when you want to use a COUNTD?