Filters Removed when adding a column via "show more columns"
With "new style" table reports, if I apply dynamic filters or use the search bar to filter the report, and then add a column (by hovering over a column header, using the "..." then choosing "show more columns" and hitting "apply"), the column gets added but all those filters get removed. The search term remains in the search box and dynamic filters that were applied stillappearto be selected in the UI (shows selected still at the top) but they are not. The filters are removed, and you have to clear and re-apply your filters. It trips me at least once a day and it's driving me nuts...I put in a support case in April, eventually QB closed it and said they tied it to a bug, but I can't be the only person that this is bothering... I understand that QB is probably/hopefully working on this and I just need to be patient. I guess I'm just looking to commiserate in the meantime with any else that is getting really annoyed about this. Can I get an AMEN??
Gauge Report - Wrong Percentage
Hi! I'm creating a gauge report that shows the percentage of POs Invoiced/Current Project Budget (aka Percent Consumed). This report is going on a dashboard that has a dynamic filter for Project Priority. After lots of trial and error, I decided to create summary fields in a parent table called "Universal Reporting Record". The summary fields specify the percentage for each priority... 1, 2, 3 and the combination of all three as All. I am then using a formula in the gauge report to specify which Percent Consumed field should be used depending on the priority: The percentage for "All" should be 13.4%, but it continues to show 17% and I cannot figure out why. The other priorities (1, 2, and 3) show correctly as the dynamic filter is changed. The calculation is done on $s Consumed/Total Budget. These are the same fields used in the summary table mentioned above, just different labels for the dashboard. Here are the results for Project Priority = 1 which are correct: Any help is greatly appreciated!!Sort & Group separate from UI
Hi, There are a lot of instances where we need the users to be able to sort and group their reports, but we can't leave the report open for editing. I've opened a ticket to see if Quickbase can separate out the Sort & Group feature from the User Interface settings. If you're interested in this too - go "request actions" and subscribe to the ticket Sort & Group #409577 - this is a link to the feedback: Request | Feedback (quickbase.com)
