BookmarkSubscribeRSS Feed
f_rederik
Obsidian | Level 7
Normally I would agree with the WRS graph builder that it would not make sense to create a bar chart with a measure on the X-axis and another measure on the Y-axis.

However, I've got a user that would like to see the volume of deposits (the account balance - a measure) spread across interest rates (another measure). "This can be done easily in MS Excel".

I've identified two possible solutions that would work in WRS:

1) I can create another variable in the Infomap that is a copy of the interest rate, and set this variable to be a category. Might cause confusion for users since there will be two variables named "Interest Rate".

2) I can request that the user define some ranges (1-2%, 3-4% etc). This will to some extent reduce precision, and depending on the ranges it might not work across different products (credit cards, mortgages, deposits, penalty interest rates etc)

Both of these have drawbacks, but the ideal solution will allow the user to do this without requiring further work in the Infomap when they discover additional variables.

Any ideas for a better approach that would create the desired graph?
6 REPLIES 6
Vince_SAS
Rhodochrosite | Level 12
I asked some of the SAS Web Report Studio staff if they knew of better ways to do this within WRS, and they did not.

Vince DelGobbo
SAS R&D
Jenn2
SAS Employee
frederik,
Just out of curiosity, why didn't you choose to create a scatterplot which allows users to build it with two measures? What are the drawbacks to your two solutions? Which did you like the best?

We have been talking about related ideas in subsequent releases so I'm interested in your responses.
f_rederik
Obsidian | Level 7
Thanks for your feedback people!

Did even think about a scatter plot, so will see how that satisfies my user.

With regards to the solutions that we have identified, (1) is very much a last resort. I have made it my mission in life to try and reduce confusion amongst our users, so struggling to see how to make this obvious "at runtime".

As for (2) I have started considering an approach that dynamically divides interest rates into deciles based on the actual rates used. That might do the trick.

If we were to implement (2) I guess the groups would be robust over time, interest rates don't vary that much. It's just that my little geek inside tells me not to "hard-code"...

Will report back on progress 🙂
Jenn2
SAS Employee
Tell me how the deciles trick works. I'm just curious.
f_rederik
Obsidian | Level 7
Scatter plot was an excellent idea. Was struggling at first, since the aggregation led to one blob in the report, the sum of account balance and average of interest rate (as per the aggregation rules in the Infomap).

When I discovered the "Aggregate or Detail" option in the data section (would be nice to have this for individual report elements too) everything was much better, and the scatter plot gave us pretty much exactly what we wanted 🙂

(We are, as you might be able to derive, following the "trial and error" approach in devicing our system)


The deciles is best solved in the datamart, and DI Studio is not my friend today (well, to be honest, it never is) so I'm strugglig a bit with the approach. Would like to build the code directly in the Table Loader in the mapping step rather than a custom code step, but guess I'll get there in the end!
Jenn2
SAS Employee
I am pleased!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 6 replies
  • 1128 views
  • 0 likes
  • 3 in conversation