Program Indicator to count the total number of options from events in a Tracker Program

[eviesn (Nelmary Evies)]

HI everyone, im using the latest version 2.41.2 I have a question related to a program indicator that is not working for me, I have a data element with an Option Set in which the options are Benign, Unknown and Malignant, the idea is that I need the total the number of each of the options.

These are all the conguration that i did

Im using count(distinct #{dataElement}) and “d2:countIfValue(#{U774xfMAjNs.Icr8F04UKW1}, ‘Benigno’) >= 1” neither of them work

Thanks a lot

[Gassim (AL-Gassim Sharaf Addin)]

Hi @eviesn

Sorry to hear that. If it’s not working, what are you getting? How do you know it’s not working; for instance, are you seeing wrong results?

Thanks!

[eviesn (Nelmary Evies)]

Hi @Gassim thanks for your answer.

These are teh results “0”

[eviesn (Nelmary Evies)]

Thanks a lot for your support

[Gassim (AL-Gassim Sharaf Addin)]

Hi again!

Did you try using a chart other than the single value?

Do you see any errors when you run the analytics tables export? (it should run first for the values to appear).

The main post in this topic deals with a text data element whereas in your case we are dealing with an option set, so I think I will need to move this to a new topic.

[eviesn (Nelmary Evies)]

Ok thanks I will try and let you know

[eviesn (Nelmary Evies)]

Hi @Gassim it works ok with the type single value, so but i have a issue with the totals because when I ckeck the totals, those are difererents with the total in database (linelisting). The total is more than the value in database

Filter

Option Set

[eviesn (Nelmary Evies)]

Thanks a lor. Happy New year 2025