topic Re: Cannot Filter my Charts in Water Cooler

Cannot Filter my Charts

zwyne — Mon, 19 Nov 2018 10:30:20 GMT

Hello everyone,

I have two charts and two list boxes. So what I want to find out if is possible or not, is a situation like

If I choose Rules = 'MajFlag' then two graphs should give me the following

on the Issues and Percentages chart, it should filter like

Major 45 61.64 and on the other chart

Issue Rule = >21% Major issues and Score =14 and so on.

Please advise.

Regards

Re: Cannot Filter my Charts

shiveshsingh — Mon, 19 Nov 2018 11:54:42 GMT

Couldn't understand your concern, can you explain it a bit more?

Re: Cannot Filter my Charts

zwyne — Mon, 19 Nov 2018 12:06:46 GMT

So on the attached app, and in particular the charts tab. On the Rules list box, when for example I select 'MajFlag' entry I expect to see the following result on the charts

1) Chart No Issues and Percentages

Major --> 45 and 61.64

2) Scores by Issue Rule

Issue_Rule Score

> 21% Major issues 14

So I am not sure if I am missing a condition on my set analysis statement or what.

Re: Cannot Filter my Charts

zwyne — Mon, 19 Nov 2018 12:09:19 GMT

Or may be is it because of the data island table, that is why I cannot filter?

Re: Cannot Filter my Charts

shiveshsingh — Mon, 19 Nov 2018 12:15:20 GMT

Ahh, nothing is coming in your Chart tab.

Re: Cannot Filter my Charts

sunny_talwar — Mon, 19 Nov 2018 12:17:34 GMT

Can you check if this is what you want for your first chart when you make a selection in 'MajFlag'?

Just added * to you set analysis... for example your expression for Major changed from

Count({$<Flags = {'MajFlag'}>} Flags)

Count({$<Flags *= {'MajFlag'}>} Flags)

and same for the other expressions in the two charts.

For the second chart, can you explain why do you expect to only see >21%? What is the exact logic driving this?

Re: Cannot Filter my Charts

zwyne — Mon, 19 Nov 2018 14:07:08 GMT

Thank you for the response. So for the same selection of Rule='MajFlag' I want the second chart to display i.e Scores by Issue Rule Chart to display

Issue_Rule Score

> 21% Major issue 14

So the logic is that they all belong the Rule='MajFlag' and similarly when Rule='LtdFlag' is selected on the filter then others will be 0 like the other one

Re: Cannot Filter my Charts

sunny_talwar — Mon, 19 Nov 2018 14:17:07 GMT

Check the attached file and image

Added conditional show/hide for your hidden expressions to only show them when the rule selects them

Re: Cannot Filter my Charts

zwyne — Mon, 19 Nov 2018 16:50:00 GMT

Thank you very much for your assistance, much appreciated.