Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am creating a new chart, The only Dimension is a date field which I would like to display as DD-MM 25-06 (drop the year) to save some space on the screen. I have created the dimension with a formula which does the job but it seems to be slower now, maybe because it has to do a calculation on the Dimension? Is there no way to leave the Dimension column with just my date field (no formula applied) and then present it as 25-06 . I could not see the Dimensions in any formatting options, only the Expressions appear in the Numbers tab where I can apply some formatting.
Thank you!
Panos.
Hi,
Create in script .
like
date(datefield,'DD-MM') as new_Date
and use this field as dimension.
Regards
Thanks but will this work as if I have a date from 01-01-2014 and another from 01-01-2015 it will add them up as they will have the same value? Not desirable, wrong result basically.
Panos