Grouping in dimensions

[#1]

Hi all,

I need a help for the below requirement.

I have the Month and product as dimension and sales as Expression.

Though the dimension is month i have to show th graph based on weekwise but in dimension it should be Month.

Ie. for Jan-15 there would be 4 weeks the n it should show the four points for  Jan 15 as continuos pints in a line graph.

Looks like.

[tresesco]

Please close the thread by marking correct/helpful replies.

[Gysbert_Wassenaar]

If your week values are already defined as WeekEnd dates then simply set the dimension axis to Continuous and change the Number format of the Continuous X-axis to a Date format with MMM/YY as format string.

[buzzy996]

the other simplest way is if u don't have weeks field in source/load script u can create that field first and use both week & month as your dimension fields in ur chart with sum(sales) as expression.

hope, tht solves ur issue.

[#5]

hi all...

one more querry..

how can i display the max and min values in the chart..as values on data points..

Regards,

Reena

[tresesco]

Hi Reena,

I suggest you to close this thread by marking correct and open a new one with this new query.

[#7]

i am not able to mark correct for this thread...thats why i added it s helpful reply..

[tresesco]

That is perhaps because, you did not mark this discussion as a question. Create a new thread and don't forget to mark that so this time because that helps you find more people answering.

For this thread mark the right replies helpful. That would help others find the solution with similar problem.