Select Next Ten Dates

[evansabres]

I have a field Event_Date.

I have a table that I only want to display the next 10 Event_Date's relative to today's date. How can I edit my dimension to reflect this?

[vishsaggi · Accepted solution]

May be try like below make sure you have same format for your eventdate and Today() date.

Sorry count does not work try Rank

= Aggr(IF(Count(If(Event_Date > Today(), EventDate))<11, Event_Date), Event_Date)

= Aggr(IF(Rank(IF(Event_Date>Today(), Event_Date))<=10,Event_Date), Event_Date)

[evansabres]

Unfortunately, this did not produce the desired result.

[evansabres]

Rank worked perfectly

[evansabres]

Actually, this output generated the 10 final dates as opposed to the next ten

[vishsaggi]

Did not get you. The next ten event dates are greater than today right?

[evansabres]

If I flip to = Aggr(IF(Rank(IF(Event_Date>Today(), Event_Date))>=10,Event_Date), Event_Date) and then restrict to the first 10 values in the dimension limits tab works

[vishsaggi]

NOt sure when you say next ten dates. Rank(IF(Event_Date > Today(), Event_Date)) Will rank the EventDates greater than today. So Date1 will be 1, 2, 3, etc. Then you are saying if Rank() of those reaches 10 then show those dates. Why do you need >=10?