Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to everyone,
i have some problems on defining calendar dimensions.
I need to define "month", "Year", "YearMonth".
This scrip works but i'm not able to sort the dimension chronologically on the graph
Your YearMonth field seems a bit strange. Are you able to use MonthName(DataOrdine) instead? If you need this exact format rather than the default MonthName() format, you can use Date(MonthName(DataOrdine),'MMM-YYYY') instead.
can you please post some values of DataOrdine loaded as Num(DataOrdine) and Text(DataOrdine) so we can see what your original data looks like and also explain your expected result of the YearMonth field?
These nested formatting and interpretation functions most likely do not work like you expect:
thanks
Marco