Value changes when single dimension selected

[cbaqir]

Hopefully this is a simple fix. In the attached example, my bar chart shows one value for a dimension but if I select that dimension, the value changes. The correct value is what is showing when only 1 is selected.

For example, if you select LCG Review by itself, it shows 47. This is correct. If all selections are cleared, it shows 34. That is not correct. Can't figure out why.

Thanks for your help!

Message was edited by: Cassandra Baqir Updated QVW with no hidden sheet

[robert_mika]

I believe that the attached example is not what you wanted to attach...

[cbaqir]

Yes, it is. If you select LCG Review, for example, the number goes from 34 to 47.

[vishsaggi]

May be this ? Can you check?

Bar Graph expression try this?

= =AVG({< CUR_GOV_PROCESS_QUEUE = P(GOV_PROCESS_QUEUE)>} GOV_PROCESS_QUEUE_TAT)

[cbaqir]

Interesting but No, that doesn't seem to give me what I need. The chart shows the CURRENT GOV_PROCESS_QUEUE. Selecting one like LCG Review should only show data for the DEFECT_ID currently in LCG Review but with your code I get multiple. Not sure why.

[johnw · Accepted solution]

You conditionally hide sheets based on user, so when we bring up the application, all we see is a single sheet with five seemingly-useless text boxes.

Your data model seems pretty strange if you're trying to link up the process queues in both tables without actually linking the tables. I can't tell you what the right data model is, but the one you have doesn't seem to support your requirement very well.

It's hard for me to know if my chart is doing what you want or not, but this seems to produce the same results as making the selection for the few selections I made.

Dimension  = GOV_PROCESS_QUEUE
Expression = avg(if(GOV_PROCESS_QUEUE = CUR_GOV_PROCESS_QUEUE and not match(CUR_STATUS,'Closed', 'Deferred', 'Denied', 'Dismissed', 'Nursing Research & Analytics'),GOV_PROCESS_QUEUE_TAT))

[cbaqir]

Thanks, John.