Count distinct number of users whose tasks are ALL completed

[ikc_jc]

Hi,

We have the following report requirements:

1. Calculate the total distinct number of users who have completed ALL tasks assigned to them
2. Apply filter on tasks

Basically, the user must be able to apply filter on tasks (e.g. by created date) and the report needs to calculate the total distinct number of users who have completed ALL their tasks assigned to them after the filter is applied.

My initial thought was to create a dynamic filter (KB0746219 ) to query the user table who have completed all their tasks and use an interactive filter.

But the issue is, how can the dynamic filter take inputs from the interactive filter from the dashboard? Is there a way to pass the inputs from the interactive filter into the dynamic filter?

If there is an alternative way to meet the requirements, more than happy to change my solution!

Many thanks in advance

[Community Alums]

Hi @ikc_jc ,

Have a look at the solution provided to the discussion above, it will help you to fit your need:

Count Distinct on Incident_Metric -> Number column

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[ikc_jc]

Hi Sandeep,

Thanks for the reply, but I don't think this resolves my issue.

Thanks