11 Replies Latest reply: May 12, 2016 8:58 AM by Manikandan Palanivel

Creating multiple charts based on single date dimension

Hi,

Please help me for this scenario. I have a date dimension column where I have dates for 1 year. I have another column for sales at the day level. I want to create 12 chart which means 1 chart per month in the year to compare the trend of sales. This will help me to know which week of the month or date range of the month or days of the month the sales increases or dips.

Thanks,

Mani.

• Re: Creating multiple charts based on single date dimension

Hi,

Check this,

From this Sample Data,

```Data:
Date, Sales
09/01/2016, 334
09/01/2016, 4
09/01/2016, 4
09/02/2016, 4
09/02/2016, 566
09/02/2016, 78
09/02/2016, 78
01/03/2016, 89
01/03/2016, 887
01/03/2016, 12
09/02/2016, 22
09/02/2016, 334
09/02/2016, 4
01/03/2016, 4
01/03/2016, 4
01/03/2016, 566
09/02/2016, 78
09/02/2016, 78
09/02/2016, 89
09/02/2016, 887
09/02/2016, 12
09/02/2016, 22
09/02/2016, 334
09/02/2016, 4
09/02/2016, 4
01/03/2016, 4
01/03/2016, 566
29/02/2016, 78
29/02/2016, 78
29/02/2016, 89
29/02/2016, 887
];
```

In the Chart by creating a Drill Down group as,

```MonthName(Date)
&
Week(Date)
```

There by using this as a Chart dimension and by using sales as expression.When you select Month , you can drill down to its weeks.

Hope this helps,

PFA,

Hirish

• Re: Creating multiple charts based on single date dimension

Your chart shows one bar per month. What I was looking for is that each chart should display one chart for month at the day level data and for 12 charts for 12 months. The reason is that I want to visually know the ups and downs for all 12 months.

Thanks.

• Re: Creating multiple charts based on single date dimension

Hi,

Can you please make your requirement on excel or Make a sample of it.

&

With your Requirement as a Plot Diagram.

-Hirish

• Re: Creating multiple charts based on single date dimension

Hi,

I believe you are looking for Trellis chart.

Attached the below image.

Regards,

Srini.

• Re: Creating multiple charts based on single date dimension

Hi, I'm aware of trellis chart. I tried that also. For each of the month the bars are getting displayed for that particular month and for other months it was blank. So it display 12 months of data horizontally but display bars for only that particular month data. I do not want to see the data for other months without bars.

Thanks.

• Re: Creating multiple charts based on single date dimension

why you want to create the 12 charts. One chart is enough to do the analysis that you want.

Just create the Calendar which will have Year, Month, Week, Quarters. You can display all these fields in listbox and just do the selections

• Re: Creating multiple charts based on single date dimension

Hi, This is a good one. But I want to see the trend at the day level to compare for each month so that I can understand pattern in the ups and downs and narrow down the date or week or weeks or range of days in the month.

Thanks.

• Re: Creating multiple charts based on single date dimension

Hi,

one solution could be to create two calculated dimensions Day and Month:

If possible,you should create Day and Month fields in the script already.

hope this helps

regards

Marco

• Re: Creating multiple charts based on single date dimension

Hi, This looks good as an alternate solution. But what I'm looking for is the one which Saikrishna Madhireddy has created using trellies. But I do not want to see the blank dates from other months.

• Re: Creating multiple charts based on single date dimension

Is this something you are looking for?

It has divided into months and you can compare dates in each month.

• Re: Creating multiple charts based on single date dimension

Saikrishna, I have already tried this. But I do not want to see the blank dates from other months. For example, for Jan chart, it currently display dates from other months in the x axis with no bars which I do not want to see. Please let me know if there is a way.