Filter on graph datasource

[Bisoux]

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

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.