Last day of the Month Set analysis

[etrotter]

Hello,

I am trying to write a formula that will show me the last day of the month data, here is what I currently have:

{<Date ={"$(MonthStart(Min(Date))-1)"}>}

Please let me know what I should be doing differently for it to recognize it

Thanks!

[etrotter]

Yes, I have a Year, Month Year,  Month, and Week dimensions

[sunny_talwar]

Your min date seems to be 9/1/2017 and you want to look at the data for 8/31/2017? But if the min date is 9/1/2017, there is no data for 8/31/2017

[pradosh_thakur]

Hi sunny

As she is using DATE as a dimension and same is used in set analysis, will it not impact and show the result as blank ?

[sunny_talwar]

I don't really know the expected output here... but what I can see is that going back one day from the minimum date is not going to work

[etrotter]

The data goes back to July, so there are multiple months, I am trying to look at the goal on the last day of the month. Is there another formula we could try?

[sunny_talwar]

So what value do you expect to see for 9/1/2017 and also 9/2/2017? Each of them should show 8/31/2017 value? Also, do you only look at this chart one month at a time?

[etrotter]

Its going to be a line graph but only one point for each month on the last day

[sunny_talwar · Accepted solution]

Oh so you are looking to get month end value for each month on a line graph? Why not create a flag for this in the script

LOAD Date = Floor(MonthEnd(Date)) as Flag

and then this

Avg({<Flag = {'-1'}>}Goal)

[etrotter]

Whoohoo it worked, thank you so much!