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
