How SSRS indicators work...
2 posters
Page 1 of 1
How SSRS indicators work...
I know that this may be an off topic but it relates to DW and the tools used to create / present reports. Microsoft have what is called Indicators in SSRS and I cannot figure out the logic that they use to determine the state - maybe you can help.
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!
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!
gabi.vasile@gmail.com- Posts : 1
Join date : 2013-05-24
Re: How SSRS indicators work...
Yes this is off topic. You should post product-specific questions to the vendor forums e.g.
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads
Similar topics
» Control Checks between Sql Tables (Facts and Dims) and SSAS Cubes?
» How do I obtain detailed reports through SSRS on an OLAP datamart?
» Codes and indicators
» Indicators in fact table
» Flat File Importing via SSIS - Best approach?
» How do I obtain detailed reports through SSRS on an OLAP datamart?
» Codes and indicators
» Indicators in fact table
» Flat File Importing via SSIS - Best approach?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum