Hi, I'm trying to make a fairly simple query in Explore, but struggling to get it to display how I'd like. We have a custom field in our tickets. This field can contain 1 of several values. I want to track the count of tickets for each value over time in a line graph.
What I've got so far:
`COUNT(Tickets)` as the Metric.
`Ticket update - Date` as the Column.
`Custom Field` as the Rows
Unfortunately, that doesn't get me a count each day though since tickets that aren't updated don't carry over day-over-day. So, I'm only counting tickets that were updated instead of ALL tickets, but I don't see an option to simply have the columns be the date. What am I missing?
Por favor, entrar para comentar.