Skip to main content

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

Hello, is there any answer for this question ? Thanks


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


Thank you!!


Reply