Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Need the Max Date of a moth and take their value. And this for each month. This formula brings correct results:
Sum({<%Date={'$(=Max(%Date))'}>} TimetoCount )
but it shows only 1 month, only the last month (Mär). Result should look like this below but with the formula above.
Thanks.
Try something along these lines:
=FirstSortedValue(aggr(sum(TimetoCount ), Date ),-aggr(only(Date) ,Date))
Try something along these lines:
=FirstSortedValue(aggr(sum(TimetoCount ), Date ),-aggr(only(Date) ,Date))