4 Replies Latest reply: Dec 19, 2013 10:21 AM by Rasmus Bangel RSS

    calendar week / year in graphic and tabel

      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