Limit the number of a specific value in a Dimension

[takama13]

Hi,

I have a table in which I would like to limit the number of a specific value :

I would like to limit the number of "Completed" to the last 2 events/records, per service.

I don't want the value "in Progress" to be limited.

Is there a way to do this ?

Thanks

[vikasmahajan]

Hi,

Simply try following 

Count({<Staus = {'Completed'}} >}   Mesure )

Thanks

Vikas

[takama13]

Hi Vikas,

Thanks for your reply but I'm not sure where you want me to add this expression ?

[vinieme12 · Accepted solution]

best option is to  flag the last 2 records during data load, can you post some sample data the best represents your actual data

[takama13]

That's what I finally did, thanks.