Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

11 Replies
Not applicable
Author

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.

Not applicable
Author

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.