Min value set analysis

[#1]

Dear all,

Currently i'm working on a dashboard regarding insurances. Some of the tables have rank numbers in the rows. Rank 1 is always the latest value. What i'm trying to do now is getting the lowest rank in combination with the date selecter in the filters.

Thus, I need to show the lowest rank with a date smaller than the date selected in my filter. I'm not sure how to explain the case more clearly. I hope someone can give me some help on this topic.

Best Regards,

Roy Covalenco

[MK_QSL]

Provide sample data if possible... Thnx

[jyothish8807]

Hi Roy,

Try to add a - sign in the expression which is giving you the Rank 1.

eg:

For Rank1: if(aggr(rank(A),b)<=1,C)

For last rank: if(aggr(rank(-A),b)<=1,C)

- sign in front of A.Try this with your present expression.

Regards

KC

[#4]

Hi Manish and KC,

I've attached a example table with dummy data.

@Jyothish KC, i'm not sure how to interpret your solution in combination with the data. The ranks are set in the data and i'm not sure how to see the if statement above. Can you clarify your answer for me?

Best Regards,

Roy Covalenco