Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
it looks like you want some sort of summary added to your chart
what expression are you using?
can you pst sample data?
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 |