topic Re: Bar Line Chart with Group and Lattice Roles in SAS Visual Analytics

Bar Line Chart with Group and Lattice Roles

Albert0 — Thu, 21 Dec 2017 01:24:27 GMT

Hi All,

I'm replicating an excel chart in SAS VA 7.1 using a Bar Line Chart Custom Category. I have attached the screenshot of the report.

The report requires 1 variable for Category role, 1 variable for Group role and 1 variable for Lattice column role then 2 Measure for the bar and line.

But in Custom Category it only accepts a Lattice column role or a Group role. You cannot add both roles.Can anyone suggest another alternative to this so that I could show the same report in the attached screenshot?

I'm using 1 Bar Chart then 1 Line Chart on the Custom Graph.

Thanks.

-Albert0

Re: Bar Line Chart with Group and Lattice Roles

FredrikE — Fri, 22 Dec 2017 07:28:54 GMT

Hi!

First of all, I think that you should redesign that graph from the start, I think it is hard to see the different values along the bars. They all have the same colour and the grouping is not that easy to see. I would have split it into separate graphs instead.

Anyhow, I gave it a try and it may give you some ideas 🙂 ?

It does not look exactly as yours thou....:)

Re: Bar Line Chart with Group and Lattice Roles

Albert0 — Fri, 22 Dec 2017 08:30:56 GMT

Hi Fredrike,

Thanks for trying...Yeah it doesn't look the same you can't also add a Group role into it right?

-Albert0

Re: Bar Line Chart with Group and Lattice Roles

FredrikE — Fri, 22 Dec 2017 09:40:39 GMT

No, I think you are right, I forgot that one...:)

//Fredrik