Incorrect data displayed at Dashboard level

[#1]

Hi,

I am facing one issue in which whenever i was accessing the last 12 month data in my dashboard then i am getting the result for 13 month data.

My calculation is based on as below:

1) I am calculating the month start date by using the below expression:

Monthstart(Date(Selling_Date, 'DD/MM/YYYY'))

This is giving me date as 1st of month 

2) I use the calculated dimension to get the 12 month data :

Date(Addmonths((Selling_Date,-12),'DD/MM/YYYY')

This issue is happening only in 1st of every month, if my system date has been change to 2nd till 30th of the month i am getting the data for last 12 months only.

Could you please advise.

Regards,

Rohit

[ahaahaaha]

Hi Rohit,

Maybe this is because you add 12 month to the original month? When the system date is shifted to another number, the one utmost month simply leaves the calculation.

If the calculation goes in the opposite direction with a minus sign, then it may be to try the interval from Date(Addmonths(CalDate,-1),'DD/MM/YYYY') to Date(Addmonths(CalDate,-12),'DD/MM/YYYY')?

Regards,

Andrey