Gauge Chart Issue

[#1]

Hi All,

Please refer attached test.QVW.

Issue is getting for PRG -> HQ

APP-> SIC

Gauge chart is giving error message.

Data is shown in Gauge chart on the basis of TS_PCT and BG_PCT.

Please see TS_PCT data for this combination. There are 3 records for this combination and for all the 3 records ' TS_PCT data value is 1. If i change any one records TS_PCT value other than 1, issue will get resolve. But i am not allowed to change this data manually.

Please tell me how can i rectify this error. Please help me urgently.

Thanks in advance.

[deepakk]

Just change the "and" to "or"

isNull(TS_PCT)=-1 and isNull(BG_PCT)=-1,

to

isNull(TS_PCT)=-1 or isNull(BG_PCT)=-1,

I hope this helps u

[#3]

It is not working Deepak.

Please help me on this it is very urgent.

[deepakk]

use SUM like below everywhere

sum(TS_PCT) < .75 and sum(BG_PCT)

you are writing (TS_PCT) < .75 and (BG_PCT) which i feel is wrong...!!!

[#5]

Thank you so much it is working fine.

Can you tell me the reason why we need to use sum(TS_PCT) < .75 and sum(BG_PCT) instead of (TS_PCT) < .75 and (BG_PCT) ?

[deepakk]

When you have multiple values in you column eg: if you have customer who has purchased 3 items..

Item Amt

A 100

B 200

C 200

Then if you wnat to see his total sales which is the combincation of these three articles you have to use sum. SImilarly in your case TS_PCT had multiple values hence you have to use some aggr function to get a proper value.