topic Re: Dynamic bar chart based off filter pane selection in App Development

Dynamic bar chart based off filter pane selection

tomf122 — Thu, 28 Jul 2022 09:26:07 GMT

I am trying to create a dynamic bar chart which would populate based off different field selections. The issue I am currently having is once I highlight multiple sections they are stacking in the bar chart and not showing up as independent bars. For the bars I have the following logic. =GetFieldSelections([Cycle]). Im I approaching this in the correct way. I had a look at the 'GetFieldSelections - chart function' but it hasnt helped me too much.

Currently:

What I am trying to achieve:

Re: Dynamic bar chart based off filter pane selection

edwin — Thu, 28 Jul 2022 12:13:36 GMT

it looks like you want some sort of summary added to your chart

what expression are you using?

can you pst sample data?

Re: Dynamic bar chart based off filter pane selection

tomf122 — Thu, 28 Jul 2022 12:40:55 GMT

For the length of the bars i am using the following which is working as I intend:

=SUM(IF(MATCH([Data Set],'Build Plan (Commits)', 'Throughputs','Budget'),
{<[Data Set] ={'Build Plan (Commits)', 'Throughputs', 'Budget'}>} value))

For dimensions i currently Im using the logic:

=GetFieldSelections([Cycle])

I am attempting to have the bars appear separate once the user selects different cycles in the filter pane. Unsure of option to keep results field selected as separate.

Sample of my data :

Cycle	Data Set	Value
May-22	Desired Build Plan (DBP)	976
May-22	NC Desired Build Plan (DBP)	0
May-22	Build Plan (Commits)	1736
May-22	NC Build Plan (Commits)	6
May-22	Throughputs
Jun-22	Desired Build Plan (DBP)	0
Jun-22	NC Desired Build Plan (DBP)	0
Jun-22	Build Plan (Commits)	1736
Jun-22	NC Build Plan (Commits)	0
Jun-22	Throughputs	21
Jul-22	Desired Build Plan (DBP)	345
Jul-22	NC Desired Build Plan (DBP)
Jul-22	Build Plan (Commits)	453
Jul-22	NC Build Plan (Commits)	12
Jul-22	Throughputs	1736