Forum Discussion
Identifying user tickets
Thank you for your reply.
However, it's returning this error:
Hello LuizKoller ,
What visualization do you reccomend for this?
I'm asking you because, I would like to bring the result into a table visualization, how ever when I try to do it I'm just getting one column with a single column which just show one requester.
I mean I need to shw the result as a table like this:
Thank you in advance,
Let me get this straight, you want a table with one category per line, the name of the user who opened the most tickets in that category, and the number of tickets, correct?
1. I would make a table putting the category in the rows and the measurement mentioned above, like this:
If you want the user not to appear in total, just make a simple adjustment to the measure:
2. Now for the total, it depends on what total you want.
If you want the total number of tickets regardless of the user, just add a count.
* My BI is in Portuguese, but I think it's understandable.
Now, if you want the number of tickets only for the user who opened the most tickers, then you need a measure.
Measure Example for Count =
VAR ExampleTable =
TOPN(
1,
SUMMARIZE(
zendesk,
zendesk[Requester],
zendesk[Category],
"TotalRequirements", COUNTROWS(zendesk)
),
[TotalRequirements],
DESC
)
RETURN
IF(
ISINSCOPE(zendesk[Category]),
MAXX(ExampleTable, [TotalRequirements])
)
(I'm not putting a print of the result because the example data in another comment does not show any user who has the same ticket category more than once)
Hope it helps