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.
From this Sample Data,
LOAD * INLINE [
In the Chart by creating a Drill Down group as,
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,
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
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.
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.
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.
Can you please make your requirement on excel or Make a sample of it.
With your Requirement as a Plot Diagram.
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.
See also: The Master Calendar
hope this helps