Cannot Filter my Charts

[zwyne]

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

[shiveshsingh]

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

[zwyne]

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.

[zwyne]

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

[shiveshsingh]

Ahh, nothing is coming in your Chart tab.

[sunny_talwar]

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)

to

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?

[zwyne]

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 

[sunny_talwar · Accepted solution]

Check the attached file and image

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

[zwyne]

Thank you very much for your assistance, much appreciated.