topic Re: Horizontal list table in SAS Visual Analytics

Horizontal list table

DBLEG — Mon, 10 Aug 2020 13:10:44 GMT

Hi,

I have a table with a few columns : Month, Amount Direct, Budget and Amount All and DS (cfr attach).

I want in my SAS VA dashboard a bar chart with Month as Category variable and Amount and Budget as measures. So far so good.

Below the bar chart, I want to see the column DS per Month as shown in the attachment.

What I need is a horizontal display of a list table but that does not exist.

Alternatively, I tried with a crosstab but I never succeed in showing only the values. I don't want to see the lines between row and column headers, etc ...

I found a solution by defining a list table per month (with filter on it) but that is not a good solution. We have a lot of similar KPI's so once you want to change an option, you have to do it for all tables seperately (same with filter on month).

How to deal with this issue ?

Re: Horizontal list table

FredrikE — Thu, 13 Aug 2020 15:39:40 GMT

It might be possible of you use the graph designer and stack two graphs on each other. The top one as the one you attached and the bottom one with the DS.Use category as shared rule and format the bottom graph so that the bars are white so only the label is visible. Change the label color (usually the same as the bars). Create a calculated measure with value=0 so that the bars are minimized.

Just a thought 🙂
//Fredrik

Re: Horizontal list table

DBLEG — Tue, 25 Aug 2020 06:57:58 GMT

If I use a calculated measure with value = 0, then I get 0 as well as data label instead of the percentage in my DS column, no ?