topic Re: % Based stacked bar chart in App Development

% Based stacked bar chart

benoitgochel — Sat, 16 Nov 2024 09:03:51 GMT

Hi all,

I have a stacked bar chart with two dimensions (Employee and SubGroupProject) in order to analyze the timesheets of the employees.

The timesheets are transactions lines with a quantity of hours and a projet-subGroupProjet-GroupProjetc.

I would like to show with a stacked bar chart the repartition in % of subGroupProject for each employee.

Eg :

But with % repartition for every employee.

I tried :

=num(SUM([#Hours.QTY])/SUM(TOTAL(<[empl.name]>[#Hours.QTY]))) as my meseaure expression

But I got no result ...

What can I do to solve this?

Thank you in advance,

shraddha_g — Mon, 13 Nov 2017 11:00:03 GMT

Please Share sample app or sample data

sunny_talwar — Mon, 13 Nov 2017 13:06:00 GMT

Try this

=Num(Sum([#Hours.QTY])/Sum(TOTAL<[empl.name]> [#Hours.QTY]))

benoitgochel — Mon, 13 Nov 2017 13:11:28 GMT

It worked.

Thank you very much.