Hello Team,
I am using Helical Insight 5.2.1.
How to calculate the percentage of individual value compared to the total value?
Hello Netta,
Often most databases support windows functions in db. We can use them in the custom column to create such kind of examples. Below we have covered an example like that.
In the custom column put code like below
(sum(“client”.“monthly_goal”) / (select sum(“client”.“monthly_goal”) from
“logianalytics”.“public”.“client”)
The query calculates the percentage of each client’s monthly_goal relative to the total monthly_goal across all clients.
Thank You,
Helical Insight Team.