SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How Indicators works


How Indicators works

Author
Message
gabi.vasile
gabi.vasile
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 220
Hello everyone - I was wondering if anyone can provide some insight on how indicators work. I read about the percentage rule but when I do the math it doesn't make any sense. Here is an example using percentage rule, with Auto for Min and Max

-- see attachment also

ITEM VALUE STATE
Item A 69,622.1990 RED
Item B 47,987.9352 YELLOW
Item C 11,237.4420 RED
Item D 12,063.1895 RED
Item E 42,324.9775 YELLOW
Item F 24,539.4310 RED


Can anyone explain why?
Here is the math:

PERC OF MAX PERC OF SUM
69,622.1990 100.00% 33.51%
47,987.9352 68.93% 23.10%
42,324.9775 60.79% 20.37%
24,539.4310 35.25% 11.81%
12,063.1895 17.33% 5.81%
11,237.4420 16.14% 5.41%

SUM 207,775.17
MAX 69,622.20

Why would 24,539 be on RED?
Thank you!
Attachments
5-23-2013 9-53-45 AM.bmp (21 views, 249.00 KB)
mysorian
mysorian
SSC Veteran
SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)

Group: General Forum Members
Points: 220 Visits: 101
Indicators are just like conditional formatting. Your text showing the table in this post is all mixed up. Why don't you leave some space to see the separate columns?
gabi.vasile
gabi.vasile
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 220
Thank you for the reply.
if the indicators act similar with conditional formating then why the need for percentage values? if we select numeric then indeed it will act as conditional formating based on numeric values; but when percentage is used it should select values based on percentage of that value from the total.

It doesn't work that way.
mysorian
mysorian
SSC Veteran
SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)

Group: General Forum Members
Points: 220 Visits: 101
Can you email me the file? I would like to check and will get back to you.

mysorian@gmail.com
gabi.vasile
gabi.vasile
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 220
I just sent you an email.
Thank you!

Adrian
gabi.vasile
gabi.vasile
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 220
OK - after some time we figured it out.
Basically Microsoft it will divide the results in the intervals specified in the options ( Red > 60, Yello < 60, etc) and based on the indicators value it will determine the state.
It will be easier to see it if you sort the data first - top 30% will be in Green, next top 30% in Yellow and so forth.
Kind of like a percentile - based on the max of you series.

Thank you!
Adrian
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search