3 Replies Latest reply on Aug 22, 2018 8:13 PM by albert wong

    How to Combine Multiple Date dimensions to Refer to in a Count?

    albert wong

      Hello TabComm,

       

      I'm trying to figure out how to make (12) separate date fields into (1) referable table in a count.

       

      I've attached an Excel sheet with an example of what i'm trying to do.

       

      On top of that, i need the Min/Max dates of those (12) fields to use as a separate dimension to build the calendar.

       

      I've added the superstore sample based on the Order Date and a Count of Customer Name.

       

      How do i join the Ship Date/Order Date into the same Count?