Dear all,
I am currently developing a dashboard, for which i have used interactive charting via checkboxes. The problem rises when i try to switch between different products. I have the different products on my x axis and the NSR on one y axis whereas the contribution margin on a secondary y axis.
I have grouped the products into three different groups. (for eg. Group A, Group B, and Group C). On one hand, when i use the checkboxes to graph only the NSR, or the contribution margin, it works perfectly.
However, when i use the checkboxes to switch between the charts for the different groups, the graphing is perfect but the values on both my y-axis turn to 0.
This is kind of urgent as i have an approaching deadline. Any help is much appreciated.
I am currently developing a dashboard, for which i have used interactive charting via checkboxes. The problem rises when i try to switch between different products. I have the different products on my x axis and the NSR on one y axis whereas the contribution margin on a secondary y axis.
I have grouped the products into three different groups. (for eg. Group A, Group B, and Group C). On one hand, when i use the checkboxes to graph only the NSR, or the contribution margin, it works perfectly.
However, when i use the checkboxes to switch between the charts for the different groups, the graphing is perfect but the values on both my y-axis turn to 0.
This is kind of urgent as i have an approaching deadline. Any help is much appreciated.