Forum Discussion

Thstorm's avatar
Thstorm
Frequent Visitor
8 years ago
Solved

Issue with a meassure

Hi, I've got a question regarding the below table. I woul like to measure how many % of our tickets is solved within time (< 30 minutes). If _request_open_time is less than 30 minutes there will b...
  • Anonymous's avatar
    Anonymous
    8 years ago

    I'm assuming that the _Solved_in_Time column is a calculated column using an IF statement? If so, output the request_id in to this column rather than a 1. then you can perform a distinctcount measure on this column against the distinctcount measure on your initial request_id column

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I'm assuming that the _Solved_in_Time column is a calculated column using an IF statement? If so, output the request_id in to this column rather than a 1. then you can perform a distinctcount measure on this column against the distinctcount measure on your initial request_id column

  • Thstorm's avatar
    Thstorm
    Frequent Visitor
    8 years ago

    Thanks so much, works like a charm!