Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be use a sort expression like this for this calculated dimension:
Only({1} transDTE)
May be like this:
If(transDTE >= MakeDate(2016, 9, 16), transDTE)
and then select 'Suppress When Value Is Null' on the dimensions tab
Hi
try this
if(transDTE>=09/16/2016, transDTE)
This seems to work, however, when I apply, the dates seem to now be out of order and are now random.
May be use a sort expression like this for this calculated dimension:
Only({1} transDTE)