Filter on graph datasource
Posted: Tue Jul 14, 2020 10:04 am
I have the following filter for my graph,
The query returns "NOTEAM" if the record is null. The All is a boolean variable. TeamN is a variable tied to a datasource and gets all team data from a datasource. I want the filter to consider "NOTEAM" if records are null but it does not look like it is doing it.
Here is a part of my mysql query for my datasource,
How can I be sure it is working as expected because right now I am not seeing records with "NOTEAM" in my chart
Thank you
Code: Select all
(Reports.teamN == TeamN || All ) || Reports.teamN == "NOTEAM"
Here is a part of my mysql query for my datasource,
Code: Select all
SELECT
CASE
WHEN r.teamN IS NULL THEN 'NOTEAM'
ELSE r.teamN
AS teamN
Thank you