02-01-2024 11:21 AM
Hey guys! I am working on an Dashboard to present workflow status.... i got this:
The query is: {Total GolfStream}{|GlobalScenario|}{|GlobalTime|}{}{}{RowType <> 'A'}
How can i remove the ones that have Central in the name?
Thanks!
Solved! Go to Solution.
02-01-2024 11:55 AM
Could you please post the configuration of the Data Adapter powering that BiViewer component? 😊 Different methods take different parameters...
You can also apply a global filter in BiViewer. Again, we'll need the list of fields to suggest the precise syntax.
02-01-2024 11:55 AM
Could you please post the configuration of the Data Adapter powering that BiViewer component? 😊 Different methods take different parameters...
You can also apply a global filter in BiViewer. Again, we'll need the list of fields to suggest the precise syntax.
02-01-2024 12:19 PM
You were right! I edited the filter directly in the BI and that worked!!! Thanks so much!
02-01-2024 11:56 AM - edited 02-01-2024 12:02 PM
Would it help to uncheck them? Unchecking them keeps all the data available, for use it needed. Otherwise edit the query feeding the DA as @JackLacava indicated. This would limit the data to only what you want.
e.g. where <columname> not like '%Central%'
02-01-2024 11:57 AM
No, we want a clean list. 😞
02-01-2024 12:21 PM - edited 02-01-2024 12:28 PM
OK, I like the solution you came up with. Its sort of in the middle. You still have the data from the DA and yet are able to filter it in the BIV. Its a good, maintainable solution.