Yes definitely, what I am not sure about is how to get the total.
what I have is count(invoice#) to get a count of the number of invoices per division
what I am not sure about is where I can get the total count for the denominator? Should I do this in the load script and create a field called total_sales
If the count shows Shoes = 15, Coats = 20, socks = 17 so
Shoes should be 15/52*100 = 28.8%
Coats 20/52*100 = 38.4%
Socks 17/52*100 = 32.6%
Thank you to all that replied , I was able to get what I needed.
Does anyone also know how to get the average of all and display on the title?
We have a bar chart that shows time to close a ticket by ticket classification.
Class1 = 20 mins, Class2 = 90 mins, and class3 = 240 mins
I would like to show on the title the avg close time (20+90+240)/3 =116.6 mins
Thank you in advance