Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have
Page and der hits.
so I need to aggregate those hits and check which page got highest hits and which got min.
I need this in text box.let me know the set expression
=only({<Page={"=rank(sum(Hits))=1"}>}Page)
=only({<Page={"=rank(-sum(Hits))=1"}>}Page)
or maybe count(Hits) instead of sum(Hits)
I have aggregated value in one column based on page.
like Sum(Hits)=TotalHitsFromPage.
I got expression for max hits
so how would set expression look like for minimum hits
BTW 2nd expression -sum(Hits) is not working