Trendline based on filters

[Simo]

Hello,

I have a graph, where I want to add trendline as in image attached. 

I'm currently using this:

if(wildmatch(GetFieldSelections([Dose_StudyDescription]),'*GD1AA*') and (WildMatch(DoseEvent_AcquisitionProtocol,'*PA*','*AP*')),100,

It works fine if I have only one filter selected (PA or AP), but I would like to have it working such way that you could select also both. 

Essentially I would change filter panel so that it would show only one selection for these two like in below.

if(WildMatch(DoseEvent_AcquisitionProtocol,'*PA*','*AP*'), 'PA', and then just select PA and it would show the trendline.

Could this be done and how?

-Simo

[MatheusC]

You can create a field in your script by unifying the values:

Table:
Load
if(WildMatch(DoseEvent_AcquisitionProtocol,'*PA*','*AP*'), 'PA','Others') as NewField,
DoseEvent_AcquisitionProtocol,
....
From[ ](qvd);

So in the graph it would be enough to use:

and (Match(NewField,'PA’)),100


- Regards,Matheus