2 Replies Latest reply: Apr 12, 2017 3:13 PM by Max Shevchenko RSS

    Share per each dimension

    Max Shevchenko

      Hi,

       

      LOAD * INLINE [

      Example, Date, Value1, Value2

      Example1, 01/02/2017, 70, 70

      Example1, 01/04/2017, 80, 80

      Example1, 01/07/2017, 50, 30

      Example1, 01/09/2017, 30, 50

      Example2, 01/12/2017, 70, 70

      Example2, 01/15/2017, 80, 80

      ];

       

      I try to find share for each date in Example

      Count(Distinct Date)/Aggr(Count( Distinct Date),Example)

       

      It calculates only for one date value per dimension(Example)

      I need share for each date.

      Thx.