Rank () Ignore selection of date

[Marcos112]

Hello Everyone,

I think it's a simple query, I need to count the dates, I'm using the rank function that gives me the expected result, the problem is when I filter by a date, the rank returns to 1, so I need it to ignore the selection of that field(Fecha)

Thanks in advance

[Kushal_Chawda]

@Marcos112  try below expression

=aggr(rank(- {<Fecha>}Fecha),Fecha)

[Marcos112]

Thanks Kushal