Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get date of last months which has highest value . dimension is Day-week.
I want to capture 15 Tuesday as shown in attachment
=concat ( distinct IF( aggr ( Rank( Count (DISTINCT
[user])), [Date Time])<=1,
[YYYY-MMM] ), ', ' , num([YYYY-MMM]))
thanks Sunny i was able to get the result
May be like this:
FirstSortedValue([Day-week], -Aggr(Sum(value), [Day-week]))
Replace Sum(value) with whatever expression you are using in your chart
Is your issue still not resolved?
hi i want to use set analysis for this to do . this is my expression in the chart
=Max(Aggr(Count (DISTINCT {<Year={'$(=max(Year))'}, Month-={"$(=month(date#(max({<Year={'$(=max(Year))'}>}Month),'MM')))"}>} [Authenticated user]),[Date Time]))
=concat ( distinct IF( aggr ( Rank( Count (DISTINCT
[user])), [Date Time])<=1,
[YYYY-MMM] ), ', ' , num([YYYY-MMM]))
thanks Sunny i was able to get the result