We have a report which is compiled manually in an Excel worksheet. It lists all organisation names, the number of tickets created per organisation. As well as the AVG number of tickets per organisation and the % difference from the AVG.
We would like this report to be built in Explore, and have successfully, with bespoke Standard Calculated Metrics created a query for a single organisation.
- Count (Global AVG Metric) - (COUNT(Tickets)/D_COUNT(Organisations))
- Count (Organisation Name) - IF ([Ticket organisation name - Unsorted]="Organisation Name") THEN [Ticket ID] ENDIF
- Count (% Difference from AVG) - ((COUNT(Organisation Name)/SUM(Global Average Metric))-1)*100
Note: We have replaced the actual organisation name with "Organisation Name"
This gives us exactly what we need, the results are correct. However, we have over 900+ organisations in the instance and it would be extremely time-consuming to create points 2 and 3 for each individual organisation, and also very impractical adding each one to a dashboard.
Could you please confirm if what we are trying to achieve is possible in Explore via another method? the above is just completely unwieldy. When you overlaying the Ticket Organisation Name as an attribute to the bespoke metrics above, the report fails and no longer computes. Ideally, we would want the organisation names as rows, followed by the ticket count per organisation and the % difference average.
Por favor, entrar para comentar.