BookmarkSubscribeRSS Feed
Not applicable
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)?

Not applicable
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?
SAS Employee
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
Not applicable
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
SAS Employee
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;
pothole 0 1
deadanimal 1 1
treeinroad 1 1

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



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 2 in conversation