topic 100% Stacked bar chart with Drilldown dimension in App Development

100% Stacked bar chart with Drilldown dimension

Eshwar1 — Tue, 07 May 2024 10:47:11 GMT

Hi All,

I have created 100% Stacked bar chart with 2 dimensions and 1 measure

Dim: Div_code, Region

Exp: Sum(Value)/Sum( Total <Div_code>Value)

the chart is displaying as expected.

but the client want to have a 100% stacked bar chart with drilldown dimensions

Div_code and Branch_code (Drilldown dimensions)

once we click on Div_code on Stacked bar chart its should show Branch_Code details with 100% stacked bar

is it possible ? if yes can you suggest the process.

-Thanks

Eshwar

F_B — Tue, 30 Jul 2024 08:57:27 GMT

Hi @Eshwar1 , yes it's possible.

Click on the Master Items on the left-hand side.

Select Dimensions and then click Create new.

Choose Drill-down and add Div_code as the first dimension and Branch_code as the second dimension.

Name your drill-down dimension appropriately and then add it to the chart.

Hope this is helpful

Kushal_Chawda — Tue, 30 Jul 2024 09:39:02 GMT

@Eshwar1 You could add branch_code in your expression which should work fine.

Sum( Total <Div_code,branch_code>Value)