topic Re: Create chart with 2 dates and 1 category Variable in SAS VA( Viya) in SAS Visual Analytics

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

mahadeep2627 — Thu, 09 Jul 2020 10:22:23 GMT

Hello All,

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

Thanks

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

BrunoMueller — Thu, 09 Jul 2020 11:29:22 GMT

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

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

Sam_SAS — Thu, 09 Jul 2020 14:14:43 GMT

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

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

mahadeep2627 — Mon, 13 Jul 2020 11:21:26 GMT

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

mahadeep2627 — Mon, 13 Jul 2020 11:30:02 GMT

thank you for Reply,

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

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

PetriRoine — Mon, 13 Jul 2020 13:43:13 GMT

Hello @mahadeep2627

Two things first.

Generally using 3D charts should be avoided..
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

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

BrunoMueller — Mon, 13 Jul 2020 13:44:20 GMT

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.

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

mahadeep2627 — Tue, 14 Jul 2020 06:40:15 GMT

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?

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

mahadeep2627 — Tue, 14 Jul 2020 07:53:44 GMT

thank you for the reply,
I will check

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

PetriRoine — Tue, 14 Jul 2020 08:21:35 GMT

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

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

mahadeep2627 — Wed, 15 Jul 2020 05:47:38 GMT

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