We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

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

Resolved

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