Hello, I am using Helical Insight 5.0.0.GIT686 RC1. I want to show split of pie/donut chart percentage wise instead of actual values?
Thank you,
Yenexow.
Hi,
In Helical Insight, by default the pie chart sections represents the actual value. In our future version, we would be adding direct option to show percentage. However for now, below steps could be followed.
To get percentage in pie/donut chart, follow the below steps:
1.Create a view wherein the SQL has % calculations in metadata.
2. Using this view generate donut /pie chart
3. Bring Percentage column in selection and keep actual value column in tooltip
4. Generate report.
Below is an example with our sample data using apache derby database.
First create a view in Metadata with SQL contains % calculations . Below is just sample SQL which we have created on apache derby database which included calculation of %.
SELECT
t."travel_medium",
SUM(t."travel_cost") AS cost,
100.0 * SUM(t."travel_cost") / g.total_cost AS percentage
FROM
"HIUSER"."travel_details" AS t
CROSS JOIN (
SELECT SUM("travel_cost") AS total_cost FROM "HIUSER"."travel_details"
) AS g
GROUP BY
t."travel_medium",
g.total_cost
NOTE : This sql is created on our sample travel data, this needs to be modified as per your database syntax.
Execute the query and then on the right side you will see the columns added to the view.
From the metadata on left select the required column in field area, percentage in label and actual value in tooltip. So you will be able to see all three values on the tooltip.
Thank you,
Helical Insight.
We had a build 830 release of RC2 of version 5.0 which by default allows to show percentage in pie/donut
Refer to this below document