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:


      - 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!