Hello,
I have a table of stats with a column "searchterm". I would like display the "searchterm" which is the most recorded.
I tried to use the count function or the topCount but without success
hi,
would the function "rank" be a solution, maybe with an extra filter (rank<2) to render just one entry? Or did i missunderstand the problem you explained?
cheerz :p
my table has a column like that :
bla
blabla
bla
bla
outlook
I want something to retrieve "bla". So I have to use count distinct and something else i think
up :/
[column]
count(distinct [column]) --> rankitem
define calculated item as rank([rankitem]) --> ranker
drag this item into detail filter section:
ranker < 2
set application of filter to 'After auto aggregation'
However, ties will still result in 2 or more rows returned