Create chart with 2 dates and 1 category Variable in SAS VA( Viya)

[mahadeep2627]

Hello All,

I need a Help for creating a chart with two date and one Category Variable in sas va viya.

Thanks

[BrunoMueller]

Some sample data and an image what the chart should look like, would help.

[Sam_SAS]

A schedule chart uses two dates and a category, but I'm not sure if that is what you want.

[mahadeep2627]

thank you for Reply,

I have tried Schedule chart which is not fulfilled my requirement.

[PetriRoine]

Hello @mahadeep2627 

Two things first.

1. Generally using 3D charts should be avoided..
2. What is it that your visualization is trying to specifically communicate? 

I know you turned down Schedule chart, but may I give you two sample images that showcase how it can be used to deliver pretty much the same information you had.

Best regards,

Petri

[mahadeep2627]

In the first bar graph how you assign the date variable as measured on the x-axis. I am getting stuck on that. can you help me with it?

[PetriRoine]

Yes,

So the object is Schedule chart and the roles are as follows:

- Task: Components

- Start: Start Date i.e. calculated item using function DateFromMDY(10, 12, 2019)

- Finish: Date

- Lattice columns: Type

To get this done I had to restructure the data like this:

Components	Type	Date
c1	Target	10.1.2020
c2	Target	15.2.2020
c3	Target	21.3.2020
c4	Target	26.4.2020
c5	Target	1.2.2020
c1	Actual	10.3.2020
c2	Actual	15.5.2020
c3	Actual	10.3.2020
c4	Actual	12.4.2020
c5	Actual	12.4.2020

The chart on the right uses data aligned like this:

Components	Target	Actual
c1	10.1.2020	10.3.2020
c2	15.2.2020	15.5.2020
c3	21.3.2020	10.3.2020
c4	26.4.2020	12.4.2020
c5	1.2.2020	12.4.2020

Brgds,

Petri

[mahadeep2627]

Hello Petri,
Thanks for a detailed explanation it will help me with my requirement.

[BrunoMueller · Accepted solution]

Thanks for explaining what you want to do.

At what date do your bars start? do you also have an actual and target start date?
Schedule chart is still the best way to start, will be horizontal. Using the custom graph builder you can overlay two schedule charts.

Or you rearrange your data such that for each category you have two lines, each line having either target or actual as a category value, then you can use the row lattice role.

[mahadeep2627]

thank you for the reply,
I will check