I have added reference bands to my 'method' chart, so they will represent the overall population even when filters are applied. The issue is the filters have been added to context for the two other charts on the DASHBOARD. With the filters being added to context the reference bands are moving with the filter instead of representing the overall population on the DASHBOARD. The filters need to be in context for the 'Reported Circumstances' and 'Toxicology' charts to work correctly. I have tried removing the filters from context for the method chart, but they get removed for the other two charts as well. I am open to a different idea than having the filters in context, but this seems to be the only thing I have figured out so far to work for the entire DASHBOARD to ensure the Top 10 'Reported Circumstances' chart and 'Toxicology' charts function are needed. Can anyone help me with this?
So here is one way;
- removed filters from context for Method %
- I created a Table Calculation filter for Method. It's name is 'Methods and it works.
- Now you can follow my method and add others too.
now do filtering
