1 Reply Latest reply on Jul 25, 2016 2:49 AM by khalid norat

    Create a constant dimension

    Matan Bracha

      Hi All!

      I have a data set with 2 dimensions - "Date" and "Source". But I don't have all of the sources in each date.

      Example:

      2016-07-25 - Source A, Source B

      2016-07-24 - Source B

      2016-07-23 - Source A, Source B, Source C

      2016-07-22 - Source A, Source C

      2016-07-21 - Source A

       

      My Measures comes from a different data set - so I DO have a value for each source in each date (but in the others data source the names don't match to how I want them to be in the view).

      Is there a way to show a constant list as a dimension so I could see all the options?

       

      Example for how I want it to be:

      2016-07-25 - Source A, Source B, Source C

      2016-07-24 - Source A, Source B, Source C

      2016-07-23 - Source A, Source B, Source C

      2016-07-22 - Source A, Source B, Source C

      2016-07-21 - Source A, Source B, Source C

       

      Thank you!!