Percentage of row over a count

posted on July 7th, 2019

Answered

Gabriel asked July 7, 2019

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