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

Calculation of Values


I have a sample data of users as below:

"id": 10040,
"status": "Active",
"username": "Tester1
"id": 10042,
"status": "Inactive",
"username": "Tester2

with this data, I have integrated Google Chart to show the total of active and inactive users. However, the options for calculating “status” was only count and distinct count. May I know how can I calculate the percentage or number of users with active/inactive and pass it to the google pie/bar chart?
Thank you.

2 answers

WebDataRocks Team WebDataRocks June 6, 2019

Hi Elisa!
Thank you for your question.

We’ve prepared a demo for you which shows how to create a dashboard with Google Charts and Pivot Table. Hope it will help understand which slice you need to define and how to pass it to charts. 

Please note that to be able to apply sum, average and other aggregations for numerical fields, the field should have the number data type. You can make the component interpret the field the way you need by setting data types explicitly. Please refer to our guides:

Hope this is helpful for your case.

Best regards,
WebDataRocks Team

Elisa June 7, 2019

Thanks for the answer!