Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to filter the data for each Date based on maximum value of Issue Type field.
I have data like this:
Date | Issue Type | resolution time |
4/12/2019 | 1 | 23 |
4/12/2019 | 2 | 56 |
4/13/2019 | 2 | 34 |
4/13/2019 | 4 | 78 |
I want to show in a chart like this:
Date | Issue Type | resolution time |
4/12/2019 | 2 | 56 |
4/13/2019 | 4 | 78 |
Try this
Dimension
Date
Expression
Max([Issue Type]) FirstSortedValue([resolution time], -[Issue Type])
Hi Sunny,
The second expression is working. But, is there any way to show "issue type" value as pop up or legend?
I am not sure I follow your question?