Chart

[#1]

Dimensions for this chart are quarters. Three different expressions. For example the one for the bars is this:

avg(if([Survey1]='Expectations ',if([Answer Flag] =1, Score)))

If I only want to see a graph with Q1 in it how should I modify my formular?

[Anonymous]

Hey,

Easy thing: Just create a list box for Quarter and select the Q1 and lock the selections.

2nd way:

If you want see the Q1 only in a static way you have to modify the set analysis as below in all expressions:

avg({<[Survey1]={'Expectations '},[Answer Flag] =1,Quarter={'Q1'}>} Score)

in you columns you should have Quarter column.

3rd way:

Also if you use below statement , users can select the quarters from any list box.

avg({<[Survey1]={'Expectations '},[Answer Flag] =1>} Score)

BR,

Chinna

[#3]

Hi Chinna,

1st way

When I lock it all my other tabs get loccked and show value for Q1 only

2nd way

I tried to apply the formula and it does not work

3rd way

This tab will need to show some other info as well, so selecting from list box Q1, would not work.

is there another way to do this?

[rubenmarin · Accepted solution]

Hi, for the 2nd way the expression should be:

avg({<[Survey1]={'Expectations '},[Answer Flag] ={'1'},Quarter={'Q1'}>} Score)

[#5]

Thank you!