Forum Discussion
Help With Aggregation
Hello! I am working on a dashboard that shows ticket counts per 1000 Employees per region, as well as overall data. I got the 'per region' data to look correct, but the overall data is giving me...
DivkLearner
Resolver I
Resolver IHello Timmo1016,
Please paste the image of your data, so we can get the idea of data and extrapolate it. Or if you have a gmail account, you can load the pbix in Gmail drive and make it public and share the link using the Insert/Edit Link.
DivKlearner, A bit forward daily.
Link to my channel on Power BI.
https://www.youtube.com/watch?v=aADx2sPA2D0&list=PLDUIC70xSiVQQpfqGhOjBVDF8IBP2k6ob
Here is the headcount data. This is only a snippet. There is data for each month for all 5 regions
Here is the case data. Same thing, there is monthly data for all 5 regions.
I also have a unique region table and a calendar table to relate these two.
Thank you!
