Forum Discussion

micklowe's avatar
micklowe
Helper I
4 years ago
Solved

Adding Up Tickets Per Day

Hi All,   I have a CSV datasource of support tickets, I want to create measures to add up opened and closed tickets per day but struggling a bit. I have tried just using counts on the field but all...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi micklowe ,

     

    If the [status] is a column in the 'Ticket' table, you could add the [status] to the filter condition.

    For example:

    close = CALCULATE(COUNT('Tickets'[id]),FILTER(ALL('Tickets'),'Tickets'[updated_at].[Date]=SELECTEDVALUE('Dates'[date])&&'Tickets'[status] = 5))

    If it's something else, please share more information.

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi micklowe ,

 

If the [status] is a column in the 'Ticket' table, you could add the [status] to the filter condition.

For example:

close = CALCULATE(COUNT('Tickets'[id]),FILTER(ALL('Tickets'),'Tickets'[updated_at].[Date]=SELECTEDVALUE('Dates'[date])&&'Tickets'[status] = 5))

If it's something else, please share more information.

 

Best Regards,

Jay

micklowe's avatar
micklowe
Helper I
4 years ago

Thanks Jay, this almost gives me what I want, the numbers aren't an exact match to what I was expecting but thats down to the data not the query 🙂