7 Replies Latest reply: Mar 28, 2018 5:25 AM by ruti t RSS

    Help with Aggr Function

    ruti t

      Hi everyone,

       

      I create Bar Char with dimensions: Region

      The measure should be: avg of (Max(to_date)-max(start_date) group by to_category,from_category)

       

      I try the following expression:

      Avg(aggr(Max(to_date)-max(start_date)),to_category,from_category))

      - But I didn't got any result.

       

      This is strange because when I create a table with the dimensions: Region, from_category, to_category

      and the measure : Max(to_date)-max(start_date) with type total - avg.

      - I have got a results.


      Could you please advise?


      Thank you!