Show aggregate values in Chart Views

  • 19 September 2022
  • 3 replies
  • 140 views

Badge +2
  • Budding Pigmenteer
  • 8 replies

I would like to be able to show Aggregate (aka SUM or AVERAGE) values in charts on Tables or Metrics. When creating an aggregate field in Pigment on the Grid View, you can see Totals or when using Show Value As you can see items like Revenue per customer (Revenue and # of Customers are two separate metrics). However, when moving to Chart View the aggregate values are not visible in the Chart View


3 replies

Badge +2

Hello, is there any answer for this question ? Thanks

Userlevel 2
Badge +1

Hi!

Yes indeed the Aggregate methods does not appear in the Chart View except for Bar chart view stacked where you can check the “show stacks totals”.

However you can set a Table with your metric and the dimension you want to aggregate in row, click on “Add this metric again” then “Collapse row” on the dupplicated metric to see the total.

 

Step 1 : Add this metric again
Step 2 : Collapse row
Here is the grid view
Here is the chart view

I hope this answer helps you 🙂

 

Olivier

Badge +2

Thank you!!

Reply