Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Yes, I have a Year, Month Year, Month, and Week dimensions
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
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 ?
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
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?
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?
Its going to be a line graph but only one point for each month on the last day
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)
Whoohoo it worked, thank you so much!