hi, Is it possible to create a column with the % of overall total. eg. showcase ‘city’ and ‘active users’ and then have a column with the % overall total?
Is this what you’re looking for: Calculate Percent of Total | Holistics Docs?
I did see this, but I was hoping for a simpler solution - Will a look at the work around.
I did see this page (
aql: % of total) was hoping this would work, but per usual need to work on a work around.
Since AQL is still in its beta mode so I have not enabled it for everyone.
However, I have just enabled AQL for your account so now you can feel free to follow our docs (
aql: % of total) to create
% Over Total.
Do note that AQL is enabled on the Dataset level so you would need to incorporate a version flag in your dataset definition as:
__engine__: 'aql' .
Please follow our document here Enabling AQL | Holistics Docs for more details