Calculated Dimension

[evansabres]

I have a field, transDTE, (it is a date field) which I would like to include in a chart. I would like to have the transDTE only display dates on or after 9/16/2016. What would the syntax be for this in a calculated dimension?

[sunny_talwar]

May be like this:

If(transDTE >= MakeDate(2016, 9, 16), transDTE)

and then select 'Suppress When Value Is Null' on the dimensions tab

[Anonymous]

Hi

try this

if(transDTE>=09/16/2016, transDTE)

[evansabres]

This seems to work, however, when I apply, the dates seem to now be out of order and are now random.

[sunny_talwar · Accepted solution]

May be use a sort expression like this for this calculated dimension:

Only({1} transDTE)