Hi Guys
I need to set up some alerts for the sales target which goes like this:
salesperson_name target %
abc 30
def 70
ghi 100
jkl 102
mno 29
Now I want my target groups like:
between 0 to 30% - Red
31% to 99.9% - yellow
100% to Max- Green
I am using spreadsheet table to achieve this but it shows yellow for 100% .
I cant edit the alert conditions in the setting.
Anyone has any idea how to achieve this?
cheers
nutty (BOB member since 2015-10-19)
Not sure, I did a test with static values and it appears to be working for me.
kevlray 
(BOB member since 2010-06-23)
which component did you chose?
Is it possible to send the .swf file?
nutty (BOB member since 2015-10-19)
I tried a spreadsheet table, but for some reason the alerts did not start on the second row (title on first row), then I tried a scorecard which appeared to work real nice. I did not save my sample. If I get time, I will re-create the sample and post it.
kevlray (BOB member since 2010-06-23)
No problem here… works fine using spreadsheet component. Attached swf.
test.zip (970.0 KB)
datawizard (BOB member since 2015-01-20)
Could you please send me the screenshot of the Alert properties settings pls?
That is exactly how I want to see the result…
I have attached my property settings here
cheers
Capture.zip (216.0 KB)
nutty (BOB member since 2015-10-19)