3 Replies Latest reply on Sep 1, 2016 6:59 AM by Andrew Watson

    Aggregation by Sum and Count

    Subha Yoganandan

      Hi,

      I am having data that look like this:

       

      type,value,year

      "K",0,2014

      "K",1,2015

      "M",0,2014

      "M",1,2014

      "M",1,2015

      "P",0,2014

      "P",0,2015

      "T",1,2014

      "T",0,2015

       

      I am making KPI / spark lines similar to this video How to Show KPIs & Sparklines in the Same Graph - YouTube

       

      So, I need the sum of value and count of the value grouped by type to produce an output similar to this image below.

      So for each "type" field, I will have the sum of "value", count of "value" and the line graph for seeing the trend over the years.

       

       

      But as you can see, only the Sum of value field is displayed and I cannot bring in the grouped count when I use a similar calculated field.

       

       

      Thanks,

      Subha