Count records with max date (over ID)

[Anonymous]

Hello everyone,

I have the following data:

ID	Date	DateType
1	01.05.2018	Special
1	10.03.2018	General
2	12.04.2018	Special
2	06.09.2018	Special
2	16.01.2018	Special
3	25.10.2018	General
3	03.03.2018	Special

The task is to draw the chart with date dimension and expression like:

Count(DISTINCT {%DateType={'Special'}>} ID). But need to display only max(date) for ID.

So, desired result:

ID	Date	DateType
1	01.05.2018	Special
2	06.09.2018	Special
3	03.03.2018	Special

How can i achieve this?

tnx in advance.

[mtucholski]

Hello, try this calculated dimension:

aggr(max({<DataType={Special}>} Date),ID)

[mtucholski]

Sorry, it should be like that:

=if(DataType='Special',aggr(max({<DataType={Special}>} Date),ID),Null())

and suppress null values.

[sunny_talwar]

Have you tried using Max(Date) where %DataType is Special as your expression?

Date(Max({%DateType={'Special'}>} Date)