SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 How indicators work ...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gabivas
Starting Member

10 Posts

Posted - 05/24/2013 :  07:46:00  Show Profile  Reply with Quote
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
http://social.msdn.microsoft.com/Forums/getfile/288519

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!

bandi
Flowing Fount of Yak Knowledge

India
2223 Posts

Posted - 05/24/2013 :  08:05:06  Show Profile  Reply with Quote
What is the problem there?
-- See the result how it calculated
DECLARE @tab tABLE(ITEM VARCHAR(10), VALUE DEC(10,4), STATE VARCHAR(10))
INSERT INTO @tab
SELECT 'Item A', 69622.1990, 'RED' union all
SELECT 'Item B', 47987.9352, 'YELLOW' union all
SELECT 'Item C', 11237.4420, 'RED' union all
SELECT 'Item D', 12063.1895, 'RED' union all
SELECT 'Item E', 42324.9775, 'YELLOW' union all
SELECT 'Item F', 24539.4310, 'RED'
/*
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 */
SELECT 
	VALUE
	,VALUE*100/ Sums AS PERC_OF_SUM
	,VALUE*100/ Maxx AS PERC_OF_MAX
FROM ( SELECT SUM(Value) OVER() Sums, MAX(VALUE) OVER() Maxx, * 
		FROM @tab 
	 )T
ORDER BY VALUE DESC


--
Chandu
Go to Top of Page

gabivas
Starting Member

10 Posts

Posted - 05/24/2013 :  08:30:20  Show Profile  Reply with Quote
Hello Chandu and thank you for your help.
According to the results, Item F (24539.4310) ends up being about 35% or so. According to the indicators rule, between 33-60 should be yellow. item F ends up as being RED.
Why is not YELLOW since is over 35% from the maximum value?
I guess my question is how do they determine the value of each indicator value? Percentage based on the maximum value in a group? the sum of teh group?

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000