topic Re: Multiple Charts side by side with different Date Ranges in SAS Visual Analytics

Multiple Charts side by side with different Date Ranges

Oscarboots — Tue, 14 Jul 2015 04:15:26 GMT

Hi Forum,

I've tried to create some charts & then put them into Horizontal containers so I can have a drop Down filter on each.

That was the theory anyway as the Drop Down filters the whole container.

Ideally, I want 2 or more charts showing weekly sales data for various Products side by side so I can compare one week with another for the Products.

Can anyone advise the best way to do this?

Thanks

Re: Multiple Charts side by side with different Date Ranges

TejaSurapaneni — Tue, 14 Jul 2015 08:27:36 GMT

Hi,

Have you tried Group option (which is available in Roles) to compare Week on Week productwise sales, achvt etc.......

Thanks & Regards,

Teja Surapaneni.

Re: Multiple Charts side by side with different Date Ranges

Oscarboots — Tue, 14 Jul 2015 21:22:04 GMT

Thanks for your response Teja,

That's an idea, but I was thinking of something like 2 Line charts that display different periods based on the same data.

I've tried creating 2 separate reports with Sliders to give the user the option to choose a time period for each.

Is it possible to put a report into a container & have its filters only work for that report?

Cheers

Re: Multiple Charts side by side with different Date Ranges

TejaSurapaneni — Wed, 15 Jul 2015 05:04:10 GMT

Hello,

Can you pleases send dummy screenshot for us.

Thanks & Regards,

Teja Surapaneni

Re: Multiple Charts side by side with different Date Ranges

Oscarboots — Wed, 15 Jul 2015 08:16:02 GMT

Hi Teja,

Here's a mockup from Excel, I would like something close to this if possible, otherwise I'll use your other suggestion,

I'd like to have the date ranges able to be selected independently for each chart so the User can select whatever periods to compare

Thanks

Re: Multiple Charts side by side with different Date Ranges

TejaSurapaneni — Wed, 15 Jul 2015 09:01:45 GMT

Hello,

The described excel example is possible in sas va.

Let me know.

Thanks & Regards,

Teja Surapaneni

Re: Multiple Charts side by side with different Date Ranges

Oscarboots — Wed, 15 Jul 2015 09:28:11 GMT

I'm not sure what you mean?

Can you advise how to do this in SAS VA or not?

Re: Multiple Charts side by side with different Date Ranges

TejaSurapaneni — Wed, 15 Jul 2015 09:38:29 GMT

Hi,

The mentioned excel example is possible in sas va.

I am getting error to attach files in communities.

I don't understand what you are trying to do "I'd like to have the date ranges able to be selected independently for each chart so the User can select whatever periods to compare". can please about this

Thanks & Regards,

Teja Surapaneni.

Re: Multiple Charts side by side with different Date Ranges

Oscarboots — Wed, 15 Jul 2015 10:03:08 GMT

Hi Teja,

I've found that I can create 2 Charts and have, for example, a drop down box that changes the filters for both charts in SAS VA, however, what I want is to have 2 charts that can have filters separately so a user can look at data from different periods in each chart in the same screenshot.

In my screenshot you could look at the WK1 - WK4 chart & compare the data from the same table for WK5 - WK8.

Hope that makes sense.

Peter

Re: Multiple Charts side by side with different Date Ranges

TejaSurapaneni — Wed, 15 Jul 2015 10:49:34 GMT

Hello Peter,

I am getting error to upload the screen shot in communities,

In theory, You have to split week column in two columns which is week1 & week2.

But you can't automate them.

I understood your requirement, i will try to upload the images in communities.

Thanks & Regards,

Teja Surapaneni.

Re: Multiple Charts side by side with different Date Ranges

Oscarboots — Wed, 15 Jul 2015 11:01:59 GMT

Thanks Teja,

I won't need to animate the charts, just view them.

If you're having trouble uploading the images, you can just give me the roles & the fields I need to use to get the behaviour I need.

For the snapshot I posted, I used the software program 'Printkey' (free version is available on the net) & uploaded my charts as an image.

Peter

Re: Multiple Charts side by side with different Date Ranges

AnnaBrown — Wed, 15 Jul 2015 13:38:28 GMT

Teja and Peter,

We had some filters on that were blocking attachments to help with SPAM. I've just lifted those, if you want to try to upload the screenshot now, Teja.

Many thanks and I apologize for the inconvenience,

Anna

Re: Multiple Charts side by side with different Date Ranges

TejaSurapaneni — Wed, 15 Jul 2015 15:00:00 GMT

Hi Peter,

Thanks & Regards,

Teja Surapaneni

Re: Multiple Charts side by side with different Date Ranges

TejaSurapaneni — Wed, 15 Jul 2015 15:01:36 GMT

Hi Anna,

Thanks for your Response,

Now the problem had been solved,

Once again Thanks.

Thanks & Regards,

Teja Surapaneni

Re: Multiple Charts side by side with different Date Ranges

AnnaBrown — Wed, 15 Jul 2015 15:10:03 GMT

Great, I'm so glad Teja.

Thanks for all you do for the community!

Anna

Re: Multiple Charts side by side with different Date Ranges

Oscarboots — Wed, 15 Jul 2015 19:29:45 GMT

Thanks Anna,

Hi Teja,

This looks great!

Can you run through how you built your example?

Do these use the same dataset?

Are they created separately & then imported into a new report?

Anything else relevant

Thanks Peter

Re: Multiple Charts side by side with different Date Ranges

TejaSurapaneni — Thu, 16 Jul 2015 08:20:19 GMT

Hello Peter,

It is completely different data, for u r understand, i made in your way..

If you need steps, i will send you,

Can you please send your week column description (only your week column).

Thanks & Regards,

Teja Surapaneni

Re: Multiple Charts side by side with different Date Ranges

Oscarboots — Thu, 16 Jul 2015 08:42:22 GMT

Hi Teja,

Can you advise the steps you took to create the charts you have posted?

I'm not sure what you mean by sending "my week column description".

My data has a 'Week_Ending' Column, Region & Sales Totals.

Please advise what steps you took to create your chart, Thanks

Re: Multiple Charts side by side with different Date Ranges

TejaSurapaneni — Thu, 16 Jul 2015 09:28:16 GMT

Hi,

I mean, how many weeks are there in Week_Ending column.

You have to Split your Week_End column to 2 columns. i.e., Month1 (Wk1, Wk2, Wk3, Wk4. Else missing) & Month2 (Wk5, Wk6, Wk7, Wk8. Else missing) These columns are for drop down list's.

Assign Bar Chart Roles (Category: Month, Measure : Sales Total & Group: Region)

For Bar Chart1 : For Bar Chart2 :

Category: Month1 (or) Week_End Category: Month2 (or) Week_End

Measure: Sales Total Measure: Sales Total

Group : Region Group : Region

put filters on Both Charts Based on Month1&2 (or) Week_End.

Thanks & Regards,

Teja Surapaneni

Re: Multiple Charts side by side with different Date Ranges

Oscarboots — Thu, 16 Jul 2015 09:36:17 GMT

Thanks Teja,

That sounds like a workaround rather than a supported feature of SAS VA.

So It looks like you have found a way to make this work, so thanks.

I wanted to know if there is a way that is already designed into SAS VA to do what I have described.

Thanks again though.