Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Date | Info |
---|---|
1 | A |
1 | B |
1 | A |
2 | A |
2 | B |
3 | A |
3 | B |
4 | A |
4 | B |
4 | B |
4 | B |
5 | A |
5 | A |
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,
maybe an action
select in field Date
='(' & Concat({$ <Date={"=count(Date)> avg(TOTAL aggr(count(Date),Date)) "}>} distinct Date, '|') & ')'
maybe an action
select in field Date
='(' & Concat({$ <Date={"=count(Date)> avg(TOTAL aggr(count(Date),Date)) "}>} distinct Date, '|') & ')'