Data filtering in chart

[Prabhu]

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

@sunny_talwar , @maxgro 

[sunny_talwar]

Try this

Dimension

Date

Expression

Max([Issue Type])
FirstSortedValue([resolution time], -[Issue Type])

[Prabhu]

Hi Sunny,

The second expression is working. But, is there any way to show "issue type" value as pop up or legend?

[sunny_talwar]

I am not sure I follow your question?