I'm having an issue with an aggregation expression that doesn't fetch the expected results.
1 - I'm looking at patients behaviour related to a treatment type (T1 and T2);
2 - Patients may have 2 different categories or status: Naive patients ('N') and experienced patients ('E')
3 - I want to count the distinct patients distribution over the treatment lifespan (Treatment Duration), by each Treatment Type and provided they have a record as Naïve patients ('N') at one of the periods available.
The expressions reads ok if I select a single treatment type but it is wronge if both treatments are selected.