Filter on graph datasource

Stimulsoft Dashboards.WIN discussion
Post Reply
Bisoux
Posts: 16
Joined: Wed Jul 08, 2020 12:30 pm

Filter on graph datasource

Post by 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
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Filter on graph datasource

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply