Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create a grphic that can be switched to a table in which I am using the date Format WW/YYYY as dimension.
I tried week(myDate) & ' / ' & year(myDate) as dimension but since it is a string the diagram is not working and it can not be sorted correctly in the table.
I tried to just use the date and present it as week of year in the diagram, but than the table showes the dates not the calendar weeks.
Can anyone help? I would be happy about some ideas.
Thanks in advance
Rasmus
You have to sort by expression and your sorting exsression should be "=min(myDate)"
You have to sort by expression and your sorting exsression should be "=min(myDate)"
you try use
DATE(POST_DATE,'WW/YYYY') as Dimension
in the configuration Sorted by numeric
Hi Diego,
yes I tried that, it delivers values only from 00/YYYY to 06/YYYY and I don't get what the numbers are actually standing for.
Thanks anyway
Rasmus
Hi Märt,
that works
Thanks a lot
Rasmus