Hey there,
Hey there,
- We are hoping to show a table view side by side where one table is hits (transactions that matched the user's filters) and the others is missed (transactions that failed one of the user's filters).
- Is there a way to do this outside of parameters?
We've been able to use group_aggregate functions for some summary stats, but unable to make it work on a table view. For additional context, ideally the user would start w/ an embedded liveboard that loads w/ pre-determined runtime filters and then the tables would change as the user adjusted their filtering options.
5 Replies
The data inside the tables would definitely change as the user would adjust their filtering options. Do you want the liveboard layout itself to change with changing filters?
No worries about the layout at this point. I realize I wasn't super clear with a question. The issue we are having is properly getting the "missed" (failed filter conditions) table to populate correctly.
What issue are you facing? Does the data not come even after changing the filters?
We are basically trying to fill the misses table with the records that fail the filters. I was hoping we would be able to use a group aggregate function or something similar to catch the records that fail the runtime filters applied to the liveboard
Our customers are in real estate, so one simple filter example would be when a property is vacant and the owner has at least 50% equity. Hits would be any sales where the property was vacant and the owner had 50+% equity. Misses would include examples where the property was vacant but the owner had less than 20% or property was not vacant and the owner had 100% equity.
Sorry for the late reply, I saw a similar query from an SRE. I am hoping you have found a resolution. If not can you try a combination of parameters and formula to accomplish this?