Total distinct count for different date ranges

vschowdary — Tue, 17 May 2022 06:37:06 GMT

HI All,

Hope every one is doing good.

i am having 2 years of data in table and need to create the 3 KPI's which are belongs to different date ranges

1. i want get total distinct count from 0 to 30 days in KPI

2. want to total distinct count from 31 to 60 days

want to get the count for >60 days in 3 kpis.

Can you please help me on priority.

Re: Total distinct count for different date ranges

Andrei_Cusnir — Tue, 17 May 2022 07:02:25 GMT

Hello,

You can use the following expressions in the KPIs:

Count(DISTINCT{<Date={"<=$(=Today())>=$(=Date(Today()-30))"}>}Value)
Count(DISTINCT{<Date={"<=$(=Date(Today()-31))>=$(=Date(Today()-60))"}>}Value)
Count(DISTINCT{<Date={"<=$(=Date(Today()-61))"}>}Value)

Here is the outcome:

As you can see it counts only distinct values for the range that you have mentioned!

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.

topic Re: Total distinct count for different date ranges in App Development

Total distinct count for different date ranges

Re: Total distinct count for different date ranges