I have the following filter for my graph,
Code: Select all
(Reports.teamN == TeamN || All ) || Reports.teamN == "NOTEAM"
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,
Code: Select all
SELECT
CASE
WHEN r.teamN IS NULL THEN 'NOTEAM'
ELSE r.teamN
AS teamN
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