Count if result incorrect after a selection

ClementByr — Sat, 16 Nov 2024 04:44:07 GMT

Hello,

I am doing some test in this sample data :

Machine_ID	Date	Num_Incident
1	2016	101452400
1	2016	101452406
1	2016	101452000
1	2016	101452447
1	2016	101452451
1	2016	101452452
1	2016	101452496
1	2017	101452000
1	2017	101452591
1	2017	101452597
1	2018	101452601
1	2018	101452614
1	2019	101452621
2	2017	101452000
2	2017	101452682
2	2017	101452690
2	2017	101452829
2	2017	101452835
2	2017	101452842
2	2017	101452843
2	2018	101452000
2	2018	101452907
2	2019	101452911
2	2019	101452915
2	2019	101452916
2	2019	101452918
2	2019	101452000
2	2019	101452922
2	2019	101452923
2	2019	101452924
2	2019	101452928
3	2018	101452940
3	2018	101452941
3	2018	101452944
3	2018	101452000
3	2018	101452961
3	2018	101453035
3	2018	101453000
3	2018	101453042
3	2019	101453048

I am trying to do a count distinct Num_Incident if Num_Incident finish with a triple 0. I have used with the formula : Count(distinct {<Num_Incident={"*000"}>} Num_Incident). The formula return the total value of 2 which is the correct answer (match the Num_Incident of 101452000 and 101453000).

But here is the issue, when I filter in a selection box Num_Incident with whatever value, the count distinct still return 2. If I select for example Num_Incident = 101453042, I still get value 2 while I am supposed to get no value.

Can anyone know a solution for this, please ?

Best regards,

Clément Boyer

Re: Count if result incorrect after a selection

sunny_talwar — Mon, 09 Sep 2019 12:54:07 GMT

Try this expression... added * before the equal sign within the set analysis....

Count(DISTINCT {<Num_Incident *= {"*000"}>} Num_Incident)

Re: Count if result incorrect after a selection

ClementByr — Mon, 09 Sep 2019 13:42:58 GMT

It works perfectly, thank you.

topic Count if result incorrect after a selection in App Development

Count if result incorrect after a selection

Re: Count if result incorrect after a selection

Re: Count if result incorrect after a selection