Forum Discussion

adumith's avatar
adumith
Helper I
3 years ago
Solved

Identifying user tickets

Hello everyone,    I have a table called "zendesk" which contains user tickets. Each one has a category assigned to it. I need to identify the requesters with the most tickets per category.   I h...
Need Help
Show and Tell
Tips and Tricks
  • adumith's avatar
    adumith
    3 years ago

    Thank you for your reply.

     

    However, it's returning this error:

     

     

LuizKoller's avatar
LuizKoller
Resolver I
3 years ago

Hello!

 

Looks like its missing the name of the measure,

 

"VAR TABLE =" is a Dax Function

 

 

It cant recognize "RETURN" because cant recognize "VAR"

adumith's avatar
adumith
Helper I
3 years ago

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, 

 

 

 

 

  • LuizKoller's avatar
    LuizKoller
    Resolver I
    3 years ago

    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