4 Replies Latest reply on Apr 24, 2017 4:38 AM by Michael Leeming

    Average of an aggregation for a group

    Michael Leeming

      Hi,

      in my workbook I work with mail data and I want to compare the amount of letters from one district (111863) to the the ones.

      So I have my dimension "district" seperated in a group(111863, other districts). In my line chart I put time on columns, my group

      on colors and for the rows I would like to show the amount of different addresses for each day of my district 111863 which is

      easily COUNTD([address]) but for the other districts I can't figure out how to show the average amount of different addresses

      because AVG(COUNTD([address])) isnt't valid because COUNTD is already an aggregation for which I can't calculate another

      aggregation.

      Thanks for help.

       

      Michael