Back to forum

In Measure (Inside slice), instead of sum I want to show "% of Row"

posted on August 29th, 2018

Resolved
variyasumit asked August 29, 2018

Hi,
In Measure (Inside slice), instead of sum I want to show “% of Row”, then what to write in aggregation?
For e.g: 

   “measures”: [{
          “uniqueName”: “Total”,
          “aggregation”: “sum”
        }
Also, Can you give me all aggregation value to show different data in the measure as given in attached screenshot.

Regards,
Sumit

Attachments:
Measure_Values.png

1 answer

Hugo Martinez ⋅ August 30, 2018

If you click Save button and open report.json file you will see the value of the aggregation field, which is percentofrow. Here is the full list:

  • "sum"
  • "count" 
  • "distinctcount"
  • "average"
  • "product"
  • "min"
  • "max"
  • "percent"
  • "percentofcolumn"
  • "percentofrow"
  • "index"
  • "difference"
  • "%difference"

Best,
Hugo

Move up