help me in writing expression?

[durgabhavani]

Hi All,

I have field billing

billing

accounts

payment

tenders

dues section

fines section

I am using billing field as dimenstion, now i dont want to display tenders and dues section columns in my chart?

Can anyone please help me ASAP.

Thanks,

Durga

[krishna20]

Hi Durga,

Try like this,,

=pick(Match(billing,'aaa','bbb','ccc'),'aaa','bbb','ccc')

Regards

Krishna

[durgabhavani]

hi krishna,

i wrote above expression in caliculated dimesion, it displaying every bar in chart. not invisible any of bar in chart.

Thanks,

Durga

[durgabhavani]

Hi Anbu,

Check my syntax error:

This is beside tenders, I am not giving complete screenshot due to security.

Thanks,

Durga

[anbu1984]

This is not syntax error.It's known bug in expression editor

[Peter_Cammaert]

Like others have said before, ignore these wiggly lines. The syntax is perfectly valid, but the syntax checker still doesn't know that.

As an alternative, add the following set expression to every expression in every chart that shouldn't display values for tenders or dues seciton:

...{<billing -= {'tenders', 'dues section'}>}...

Again, ignore any wiggly lines.

Do NOT check Show All Values in the dimension tab.

[durgabhavani]

Hi Anbu/peter,

I got the point, your caliculated dimension is absolutely correct. thanks everyone.

One more small help required here is, Now i wrote multiple expressions and stacked the barchart like below :

1st expresion is count(priority1_alerts)

2nd expression is count(priority2_alerts)

3rd expression is count(priority3_alerts)

Now i need to hide bars with that caliculation dimension and these expressions.

I tried with that dimension and these expressions it is not working i.e not reflecting any changes in chart.

Note: i dont have possibilty to write other expressions expect above.

Please help me! I need to go for testing tommorow EOD.

Thanks,

Durga

[durgabhavani]

Hi Anbu/peter,

I got the point, your caliculated dimension is absolutely correct. thanks everyone.

One more small help required here is, Now i wrote multiple expressions and stacked the barchart like below :

1st expresion is count(priority1_alerts)

2nd expression is count(priority2_alerts)

3rd expression is count(priority3_alerts)

Now i need to hide bars with that caliculation dimension and these expressions.

I tried with that dimension and these expressions it is not working i.e not reflecting any changes in chart.

Note: i dont have possibilty to write other expressions expect above.

Please help me! I need to go for testing tommorow EOD.

Thanks,

Durga

[anbu1984]

Do you have only one calculated dimension or you have more than one dim?

If you have only one dim, then it should work with any number of expressions

[Peter_Cammaert]

Can you post a screenshot of the stacked bar chart?

[durgabhavani]

Hi Anbu/Peter,

Its working with all expressions. Thanks a ton! I will sleep tonight...

Once again Thank you very much for spending time for me.

Durga..