+- Forums (https://bdn.bdb.ai)
+-- Forum: BDB Knowledge Base (https://bdn.bdb.ai/forumdisplay.php?fid=13)
+--- Forum: BDB Dashboards Designer (https://bdn.bdb.ai/forumdisplay.php?fid=43)
+---- Forum: BDB Designer Q & A (https://bdn.bdb.ai/forumdisplay.php?fid=16)
+---- Thread: how to use BDB platform Filters in Data sets..? (/showthread.php?tid=445)
how to use BDB platform Filters in Data sets..? - mohd.gulam - 12-23-2022
Suppose we are creating data set in that we want to show the data based on selected row in a column:-
1)select name,gender,sum(amount) as total from restaurant_data where gender =@gender@
so when we run this query in data set it gives gender column data=Male and female ,based on select it shows data accordingly..
All filter
2) select name,app,gender,sum(amount) as total from restaurant_data where (app=@app@ or "All"=@app@)
* it means if we select ALL in filter ,it shows data for all Apps,,