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
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.
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.