Hi all,
I've created a measure that looks at one field in a table, ISSUE PRIORITY (values can be normal, major, critical) and then compares another field, REACTION TIME with the relevant user input parameter (The user inputs a value for each priority) and if the reaction time is higher thatn the parameter, it flags it as a violation. The user can then use this to filter to show only violations.
Being a measure, I have to use max(priority) rather than priority in it. This works when each ticket is displayed separately, like in a table.
However, if I'm looking at grouped values, such as number of violations per month, in a line graph, it won't work as the measure will look only at the max(priority) of that month, so it will look at one issue. I need it to still look at each individual issue, work out which are violations so the user can filter on just them and then group them so we can look at metrics by the month such as number of violations, average reaction time etc. Possible? Can someone point me in the right direction if so?
