BI Dashboard - 2 simple indicator values in same indicator?

[deleted_user]

I wasn't sure where to ask this question since there is not a forum specifically for BI Dashboard, so hope this place is as good as any.

I need to show 2 different but simple measures for the same category. Essentially, there are 20 categories and 2 measures for each (like a simple table). I would rather show them in the same indicator using a button guage, but am struggling to find the proper gauge type.

For example, the is POT HOLE Complaints, and the two measures are whether there is an issue with how long complatins have been open: 1 measure for Crticial Complaints, one for NonCritical Complaints. I don't want to use a dynamic gauge because they mix the two measures, and the measure is very simple (1=issue, 2=caution, 3 = good) for both.

The closest I can find is using a bar and trend gauge - I am using button guages for each the bar and the trend, and it seems to work except I cannot turn off the range display on the bar measure because it was expecting a dynamic gauge.

Any thoughts on an alternative?

Do I just have to create two separate indicators (not desired)?

Thanks!

[AngelaHall]

Have you tried the kpi table display?

9.1.3 Indicators are referenced here:
http://support.sas.com/onlinedoc/913/getDoc/en/bidbrdug.hlp/a003177357.htm

9.2 Indicators are referenced here: http://support.sas.com/documentation/cdl/en/bidbrdug/61856/HTML/default/n1ft1fnpq8qa7on1vy9593s74h2w...

~ Angela Hall
http://sas-bi.blogspot.com

[deleted_user]

Hi Angela - thanks for responding. I did try a KPI table, which is the format I would prefer, but it seems like it only allows you to list a single measure, not multiple measures. Do you know how to get it to list multiple measures?

[AngelaHall]

I'm looking up some documentation on that. In the meantime, how is your source table formatted? Is it like this column structure:

Column A = Timeframe (Text)
Column B = Critical Complaints (Numeric)
Column C = Non Critical Complaints (Numeric)

~ Angela Hall
http://sas-bi.blogspot.com

[deleted_user]

Public Complaint Type: Pothole, Tree in Road, Water on Road, etc)

Critical Status (1=issue, 2=caution, 3=good; this is this way because I also need to have the source table feed a crystal report) - the value of this is based on the set of complaints that are are flagged as critical, and the max # of hours outstanding.

NonCritical Status - ordinal measure of 1=issue, 2=caution, 3=good; this is this way because I also need to have the source table feed a crystal report) - this value is the based on the same thing as Critical but the set of complaints that are non-crticial.

There are approx 26 complaint types, so there are 26 rows. There are other columns but the ones above are the measure columns that matter. Other columns contain things like Counts of Critical Complaints, Counts of Non-Critical Complaints.

This is read into the table near real time so time is not a variable (time is "near real time).

In essence, I seek a very simple indicator:

Problem Type Critical Complaints Non-Critical Complaints
Pot Hole
Dead Animal
Tree in Road
etc

where button is either red, yellow, or green.

Manger will select row and this will send them to a WRS report that lists the complaints in decreasing age, highlighted in red, yellow, or green based on the age thresholds that are associated with the values 1, 2, and 3.

Seems like it should be a very simple indicator?

[AngelaHall]

Sorry for the delay. After some testing, I was able to get a similar display by completing the following steps.

In 9.2 - I created a quick sample table with 3 columns (complaint type, critical status, noncritical status).

data bidash.kpitable;
input type $ crit status;
cards;
pothole 0 1
deadanimal 1 1
treeinroad 1 1
;
run;


Creating the Data Model off this table, I verified that the 'category label' for both measures was set to type.
Creating the indicator, I ended up picking the 'Bar & Trend' indicator. This allows the ability to define different values, ranges and gauges for primary & secondary values.

In the portal, when viewing this indicator I now see
Type - indicator - critical # - indicator - status #


~ Angela Hall
http://sas-bi.blogspot.com