YTD Insight with Count Distinct

[GeorgeQS]

Hey team,

I need to create a YTD insight versus the previous year with a field aggregated with Count Distinct, yet this throws up errors as below:

I need to use the Count Distinct aggregation for the data as otherwise the dataset is double and triple counting some values. It’s an issue with the data I can’t figure out. I have tried aggregating the value with Count Distinct in SQL and this isn’t displaying the correct distinct number of the value:

So I’m wondering if there are workarounds for running period-to-date insights with Count Distinct values…

[Koushik_Muthanna]

@GeorgeQS ,

Could you provide a few more details on the issue itself ?

I am using period to date insight along with a table to validate if the numbers are correct

Kind regards,
Koushik

[GeorgeQS]

Hi @Koushik_Muthanna ,

in the example below this is a period-over-period insight, I’m looking for a period-to-date insight. For example, I want to compare the total distinct count of ‘#NCRs’ for the year to date period, with the total count for the last year to date:

Period to date:
‘Year-to-date total distinct count of #NCRs for Oct 8, 2023 decreased by 10.87% (-157) from 1,444 to 1,287 (2023 YTD).’

[GeorgeQS]

@Koushik_Muthanna I haven’t heard back from you… Is this functionality possible?!

[Brett]

Hi @GeorgeQS,
It’s been awhile since last activity on this thread, were you able to find a work around for your case or did you have any remaining questions?

Maybe check out this past community post to see if it helps with your case.

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

Thank you!

[Brett]

Hi @GeorgeQS,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!