I have a tag. Let's call it TagA. I need to calculate the average over a time interval of 14d when 'TagA'="OPEN"
That's the easy part. I have four more tags. Tags B-E respectively. I need to calculate the average of TagA when OPEN when at least 1 of the other four tags is "FLAME".
So I tried 'TagA'="OPEN" and 'TagB'="FLAME" or 'TagC'="FLAME" or 'TagD'="FLAME" or 'TagE'="FLAME"
From that I got an impossibly high value.
I believe my syntax is incorrect. How can I fix it so that it will do what I want?