Evaluation of indicator condition in case of record aggregation

[Matus Kvackaj]

Dear experts,

I have a Metric definition, that stores a value of a different field, whenever a different checkbox field is set to True.

I have built an indicator upon metric_instance table and I would like to make a statistic on a count of records with a certain value (let's say XXXX). However, for one ID (which is a reference to the task) in the metric instances, I do not want to count multiple times, only once! This tempts me to use the 'Count distinct' aggregation on a field ID, but here's my question:

Let's say I have following metric instances:

ID:11111 Value:XXXXX

ID:11111 Value:ZZZZZ

ID:11111 Value:XXXXX

ID:11111 Value:YYYYY

Indicator condition is: Value is XXXXX and Aggregation is set to 'Count distinct on a field ID'.

Will it evaluate results as 1(we have count distinct aggregation and in at least some records the indicator condition was true) or 0 (not all values are XXXXX and we have aggregation)?

Thanks in advance

Matus

[Matus Kvackaj]

Many thanks, this is exactly what I needed.

[Matus Kvackaj]

Sorry but this seems like an output from the ChatGPT, sadly. I would appreciate if anyone else could share their experience...