Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How Indicators works Expand / Collapse
Author
Message
Posted Thursday, May 23, 2013 8:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 19, 2014 9:35 AM
Points: 6, Visits: 156
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!


  Post Attachments 
5-23-2013 9-53-45 AM.bmp (17 views, 249.87 KB)
Post #1456026
Posted Monday, June 10, 2013 5:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 5:39 PM
Points: 40, Visits: 79
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?
Post #1461820
Posted Tuesday, June 18, 2013 7:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 19, 2014 9:35 AM
Points: 6, Visits: 156
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.
Post #1464657
Posted Tuesday, June 18, 2013 12:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 5:39 PM
Points: 40, Visits: 79
Can you email me the file? I would like to check and will get back to you.

mysorian@gmail.com
Post #1464835
Posted Tuesday, June 18, 2013 12:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 19, 2014 9:35 AM
Points: 6, Visits: 156
I just sent you an email.
Thank you!

Adrian
Post #1464842
Posted Thursday, June 20, 2013 7:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 19, 2014 9:35 AM
Points: 6, Visits: 156
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
Post #1465709
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse