Pickups per day result not giving proper result

Hi All
Can any one tell me solution for my question

in my dashboard i have used relative dates filter there i have used return_drop_date in the filter

in the card i have mention total_pickups per day

like below formula
{picked_up_count} / (dateDiff(min({return_drop_date}), now(), ‘DD’) + 1)

expecting output will be if user select month in the relative date filter as month to date
output=total count/number days in this month (23)
if user will filter this week then denominator will be 5

like that denominator will change automatically

in the min({return_drop_date}) field required start date based on user selection

regards
b vinod kumar

hi @vinodkumarb

for you case, I suggest that could be better if you first: creat all dates that you need in calculated fields, and them related to parameters.

Hi @vinodkumarb,
It’s been awhile since we last heard from you on this thread, were you able to find a work around or do you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Hi @vinodkumarb,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!