Bar chart filtering

[#1]

Hello all!

On my graph above, I do not always want to see that fourth bar over, 'Inventory Adjustment'.  I want the chart to default to not have it included in there, but once in awhile I will need to see it.  Any suggestions of what I should do?

Channing

[mphekin12]

Can you just add a list box and select just those values that you want displayed?  See attached file.

Hope this helps!

[#3]

Thank you for your suggestion, but the chart is filtered to just show the top 8 (inventory adjustment is usually on that top 8).  I already do have a list box so the user can select a value that is not shown in the top 8. There are so many values of code text in that list box, that I really do not want to hard code, because new values are added all the time.

[mphekin12 · Accepted solution]

Is it just the Inventory Adjustment Code Text that you want removed from the chart?  If so, see the second tab on the attached app, it should at least point you in the right direction.

[effinty2112]

Hi Channing,

I would consider adding a second expression but with a set modifier in it like

<[Code Text] -='Inventory Adjustment'>

You don't want to show both at the same time, you'd prefer to toggle between them so you could create a variable say, vShowInvAdj, that toggles between 0 and 1 and set the display conditions for the two expressions based on the value of this variable.

Set the condition for one to $(vShowInvAdj) and set the other to 1- $(vShowInvAdj).

Make a button with a Set Variable action vShowInvAdj =1-$(vShowInvAdj).

Hope it helps!

[#6]

Yep! Just the inventory adjustment code text.  Did you attach an app?

[#7]

Nvm I see the attachment in this view haha.  Thanks so much!