Month to date chart

[anuradhaa]

I need to plot the data in a line chart.

demenssion is dates (1,2,3,4,5.....)

i need to have two lines one reprecent curent months data for the relavent day and other reprecent prv.month data.

ex - i have 100 for may 5th and 400 for june 5th.

so i need to have both the values in same chart which has the days in X-Axis.

I know how to do this with month and years. but can't find a solution for month and days.

Thanks

[tresesco · Accepted solution]

Anuradha,

Go to the variable declaration section and put '=' before the expressions of the variables.

Thanks.

[narender123]

Hi Anu.

Your qvw is not working because you have not added = in your documeny property>variable>

Here u have written

Month(Max(date))

replace it with

=Month(Max(date))

Thanks

Narender

[narender123]

Find the attachment

[anuradhaa]

Greate , it works.

Thank you very much

[anuradhaa]

Thanks, Narender.

Thank you very much. i didn't select your answer as Correct answer, because tresesco give me that answer first. Your answer also correct. sorry for that.

Have a Nice day .