Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 How indicators work ...

Author  Topic 

gabivas
Starting Member

10 Posts

Posted - 2013-05-24 : 07:46:00
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
[url]http://social.msdn.microsoft.com/Forums/getfile/288519[/url]

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
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-05-24 : 08:05:06
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 - 2013-05-24 : 08:30:20
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
   

- Advertisement -