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

Percentage of row over a count

Answered

Can I use percetage of row or column for calculated values over a count of a non numeric field?
Example:

  • I can count Men and Women crossed over differet regions.
  • Can I do % of M and % of Women?

Thanks

1 answer

WebDataRocks Team WebDataRocks July 12, 2019

Hello Gabriel,
 
Thank you for the question.
There is no built-in feature to do so with non numeric fields.
As a workaround, you can add an additional “counter” numeric field for every data entity that equals 1. And use that field with percent aggregation.
 
Hope it helps.
 
Regards,
WebDataRocks Team