Forum Discussion
Filter bar chart depending on field parameters and hide bars when there are no comparison values
Hi,
You do not need field parameters here. See the second page of the file.
This is not the expected behavior.
I don't want to calculate an average when more than one color is selected.
Blue is the base index (always 100), so there should be no filter option for blue. It should be always displayed.
When you choose one of the three additional colors (green, red or yellow), the bars should be displayed additionally to blue, so you can see a direct comparion for each product (e.g. one bar for blue TV 100 and one bar for green TV 334).
But I want to hide the products which do not have a second bar/comparison index after applying the filter color, e.g. green has no value for Tablet, so when you select green, the product should be completely disappear from the bar chart, although it has the index value 100 for blue.
- Ashish_Mathur7 months ago
Super User
HI,
File attached.
Hope this helps.
- Cookie_Lover7 months ago
Helper I
Hi,
that is the expected result. Thank You! However, it woulde be nice to have the name of the currently selected color in the legend of the diagram instead of V for all three colors.
- Ashish_Mathur7 months ago
Super User
You are welcome. Do not know how to do that.