6 Replies Latest reply on Oct 8, 2018 4:24 PM by Don Wise

    Creating decades from Years using calculated fields

    Adeleke adefabi

      I have a date dimension called [Year] and would like to group into decades [Decade] and keep as a date formatted dimension so that I can use in a line chart or any chat that will enable me to show trends. I was able to use the group function to create decades out of the dimension(by grouping years together) but I want  this to be to be done using date calculated field and also to create a forecast viz that will enable me to split the dimension (year) into quarters.

       

      Attached is workbook that contains the Data set.

      Your assistance will be highly appreciated.

      Thanks