Selecting Dates with button

Thu, 24 Sep 2015 17:13:33 GMT

Hello,

I was wondering if anyone knows how i can create a button, that selects the dates where theres more information that the average.

For example, i got my Data:

I would like to have a button, that when i press it, it would return the selection of the dates that have more than 2.6 lines, in this case 1 and 4.

Anyone knows how i can do this?

thanks for the help,

Re: Selecting Dates with button

maxgro — Thu, 24 Sep 2015 17:37:24 GMT

maybe an action

select in field Date

='(' & Concat({$ <Date={"=count(Date)> avg(TOTAL aggr(count(Date),Date)) "}>} distinct Date, '|') & ')'