BAQ filtering

[pilio.lee]

Hello everyone,

I am new to BAQ and I am creating a report in BAQ. I want this line to not appear if the values in these columns are 0.
This is a very basic question, but I would appreciate it if you could elaborate.

[Banderson (Brandon Anderson)]

I don’t know exactly where you’re getting the column from, so the answer might vary. And either way you have multiple options

1. You can simply leave it in the BAQ and do the filtering in the dashboard. When you bring in the BAQ there are filtering options on the baq so you can say don’t show rows when a value is 0.

2. You can do a subquery filter, which will filter the results after everything gathered. There are some situations where it doesn’t let you do this, related to calculated field and such. If that’s the case, you can make your top level into a subquery and bring it into a new top level and filter on the “table” of the subquery.

3. You can filter the table that has that value so it only returns rows that aren’t 0. This is the best option, so do this if you can.

[pilio.lee]

@Banderson

You can filter the table that has that value so it only returns rows that aren’t 0. This is the best option, so do this if you can.

Thanks for the advice!