count based on latest date

[Zahmed14]

Hello guys , 

i need to make a count ID and by status based on  Max date 

Also how i get the status for the latest date 
Maxdate is expression i wrote :  =aggr( max(UDATED),OBJNR)  .  how to put that count in charts 

[Ksrinivasan]

hi,

you can use Straight table,

DIMENSIONS are 1. MAXDATE, 2. STATUS

MEASURES is 1. Count(ID)

ksrinivasan

[Zahmed14]

how can i put this count in chart or  KPI componant  counting by status type

How to get the latest status  for every ID

[Ksrinivasan · Accepted solution]

hi,

1. you have to create variable to get  Latest Date as below

2. we will Call the Variable in in pie chart

1. DIM=STATUS

2. MEASURE=count({$<MAXDATE = {'$(=vMaxdate)'}>}COUNT_ID)

result as below:

ksrinivasan.

[Zahmed14]

thats good but  " MAXDATE " was experssion in table i wrote  ... so it gives me error when i write it in the variable of VMax_date

[Ksrinivasan]

hi, no need to maintain separate MAXDATE expression for table.

you can use same  Variable: vMaxdate =MAX(MAXDATE) for both Table and Chart as Expression and DIM also.

as below 

ksrinivasan.

[Zahmed14]

I mean the MAXDATE in blue circle   

[Ksrinivasan]

hi,

what you have marked blue box value is field name, its from your table last field.

its not considered here as dimension , expression and formula.

ksrinivasan.

[Zahmed14]

No thats what am trying to say .  the blue field is an expresion i wrote in my table  not a field name coming from source  i just wore this exp in table  "=aggr( max(UDATED),OBJNR) " to get the blue field 

so it will not appear when i create my variable    

[Zahmed14]

how to get latest status for ID  in chart or table ?