22 Sept - 16:00 - Tracker and Program Indicators - Experts Lounge Q&A

[Markus (Markus Bekken)]

@Kris_Reinhardt

Hello Experts! I have a questions regarding the use of the d2:condition.

When using multiple d2:condition in the expression, can the true-expr or false-expr be set to null? Our use case is that we have three tracker data elements that collect coded options from the same option set, we want to count the number of times per event a particular option is selected considering all three data elements. So far we have set this up using multiple d2:conditions in the expression (d2:condition("#{dataElement1}='optionCode1'",1,0)+(d2:condition("#{dataElement2}='optionCode2'",1,0)+(d2:condition("#{dataElement3}='optionCode3'",1,0) . However, this makes pivot tables difficult to read because the PI can calculate to 0 if none of the conditions are met. Is there a way to get rid of the zeros so the program indicator presents only values greater than 0?

(currently on v2.33.4)

Interesting question @Kris_Reinhardt! Have you tried using a filter, including only records where at least one of the legal values are present?

Markus