Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a list box with an expression that is supposed to show a mini trendline covering data from the last 4 weeks (below).
Unfortunately, the expression I am using to extract the values for the last 4 weeks is not working.... The underlying data is shown in the table on the left, however my expression:
=Aggr(If(Rank(DashboardDate) <=4, [Total Logged Last Week]) ,[Total Logged Last Week])
appears to be bringing back the data shown on the right.
I would like to bring back only the top 4 dates (sorted descending) and their corresponding values - can someone help me see where I am going wrong?
Thanks in advance!
Try a dimension DashboardDate and as expression
=Sum({<DashboardDate = {">=$(=Date(Max(DashboardDate,4),'DD/MM/YYYY'))"} >} [Total Logged Last Week])
Try a dimension DashboardDate and as expression
=Sum({<DashboardDate = {">=$(=Date(Max(DashboardDate,4),'DD/MM/YYYY'))"} >} [Total Logged Last Week])
you can use an advanced search to get the top 4 weeks
sum({< DashboardDate ={"=rank(Sum(Total Logged Last Week])) <= 4 "}>}[Total Logged Last Week])
This didn't work unfortunately 😞
Perfect!! Thanks!!