Problem with GroupBY

[luigi.arena]

Hello,
I have a query this example:

Code: Select all

SELECT xyz,                                                                            
        SUM(CASE WHEN FieldA BETWEEN 100 AND 200 THEN (Field3+Field3)-(Field4+Field4) ELSE 0 END)
FROM MyTable
GROUP BY xyz

In Sql server I view the data, in Dashboard I view the data but in Preview or runtine the data is empty.
If I delete group by of the query I can view the data but this is a problem because I need to group by the data and then apply a filter
Help Me.

[luigi.arena]

If in Dashboard Value I write Sum(Name field) it's work.

The problem is I have the combobox in Page and I have two datasource and two chart one for each datasource, the combobox filter only the first datasource, but I do not know if I delete the combox I can view all data in both chart else I can view only first chart data.
This is possible ?

[Lech Kulikowski]

Hello,

You can use the 'Group' property of each element to combine elements in one data source group.

Thank you.

[luigi.arena]

ok thank

[Andrew]

You are welcome!