Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
my goal is to do the sum of a value field (TIR) only for those dates that are beginning of the month
=sum({<Data{'$(=monthstart(Data))'}>} TIR)
where am i wrong?
I try the formula but the result is the same..all the months report also the value at start of month.. 😞
With me:
=Sum( if(Day(Data)=( Aggr(NODISTINCT Day(Max(Data)), num(Month(Data)))), TIR))-Sum( if(Day(Data)=1, TIR))
I tried to insert this variation to don't touch the script editor but the result is not consider the initial data..
I think that the solution is to create a field "Month" in the table...although this slightly changes the snowflake structure with Syntetic keys..
Aggr() can't work on calculated dimension but field created in the script.
@tresesco thank you so much for your patience! Have a good day!