We are trying to generate a query that counts the number of specific requests and lists the customers who requested it. We are currently using a custom metric with a fixed attribute on the Supports: Tickets dataset :
ATTRIBUTE_FIX(D_COUNT(Tickets), [Ticket Field])
The table is close to what we are looking for, but the totals are incorrect.
For example, we have a common request to alert users when the driver/truck is late. This was requested by Customer 1, Customer 2, and Customer 3.
What we would expect to have on the table:
What is actually on the table:
Is there any way to show the total tickets on the first line only?
Vous devez vous connecter pour laisser un commentaire.