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)?
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?
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
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).
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 #
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.