Top 15 DATETIMES

[#1]

My date field has a time stamp.How can I create a calculated dimension which displays only Top or Recent 15 date times. Dimension limits didn't work when i select show only first 15 values.

[sunny_talwar · Accepted solution]

May be like this for your calculated dimension:

If(Max(TOTAL DATETIMES, 15) <= DATETIMES, DATETIMES)

[#3]

Great,it worked

[#4]

stalwar1‌:If I use that expression as calculated dimension,I am not able to select a specific datetime .If I select any datetime field then the straight table gives zero results.Is there any way to over come this??

[sunny_talwar]

How about if you try this:

If(Max(TOTAL {<DATETIMES = {"<=$(=Max(DATETIMES))"}>} DATETIMES, 15) <= DATETIMES, DATETIMES)