Forum Discussion
Calculating cost based on average ticket count
Hello Anonymous,
I did an unpivot and got the new measure which is helpful. That solves part of my problem. How do I get that new measure to multiple by the number of tickets per account over the year and get a sum of the total cost? Since I would like the visual to be a column chart or something similar.
What I want:
new measure * number of tickets for account (but for each agent).
e.g.
Alpha cost $306.75 for each ticket created in 2021 but created 10 tickets for Smith Co.
Alpha total for Smith Co:
306.75 * 10 = 3067.50
Beta cost $206.19 for each ticket created in 2021 but created 5 tickets for Smith Co.
Beta total for Smith Co:
206.19 * 5 = 1030.95
Total cost for Smith Co. = Alpha total + Beta Total + etc...
Then sum them all together over the year and to be able to slice the data with an account slicer to show the different accounts total throughout the years.