Max daily performace over a time peroid

[#1]

Good afternoon

I'm looking to create a simple stright table which shows number of leads generated with in given time peroid (selectable list boxes), the average number of leads created and the maxiumim number of leads generated with in a single day.

The first two parts were easy, how ever im stuggling to create a forumla which calculates the maximum number of leads produced in one day. Can anyone help?

Cheers

Shaun

[#2]

Hi there, the expression should be similar to the following:

max(aggr( count(distinct [Lead ID]), Date))

Regards