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

Percentage of row over a count


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

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


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.
WebDataRocks Team