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!!
Summary Reports
Y'all have been so helpful! I'm hoping I can figure this one out! I need to create a summary report thatshows these totals in an easy report. I can't seem to figure out how to only have current MTD or YTD, just group by Month or Year, which isn't what I need. I can create a KPI widget for everything, but is there a way to show the KPI numbers in a chart that can be exported for our company analyst group? I'm hoping there's a relatively easy way to do this! Thanks!
Specifying the Report Used in Reminder Notification
I have a "Reminder" notification setup to trigger when a date field is after the value by a certain amount of days. Is there a way to specify the report to use when sending this email? Right now it is using the "Default Report", but I would like to change to a different report if possible. Thanks Brian
Report Help - Multiple apps/tables
Hello. I'm looking for some assistance/guidance with reporting for our QA team. We have multiple apps built for different review types. We would like to have a separate report or maybe dashboard that could show how a specific Line of Business is doing as a whole across all different types of reviews being completed. For example, we have an app for Review X, Review Y, and Review Z. Each of those separate review processes provide great reports for that specific review. We want to pull data from Review X, Review Y, and Review Z to show how a specific Line of Business is performing across all reviews. Kind of shooting for an end result overall QA score for each LOB. Would this be a time to utilize the table to table relationships or what would be the best/easiest way to create this type of report or dashboard? Our team is new to the QuickBase world and have been using since March 2024. ThanksHow to split an Export file which is too big
I need to export port a file which has over 400 fields and years of data. When I try to export I get the following error. is there a way to split the data into chunks? I still need all the data, and would like to split in yearly chunks. Is there a simple way to do this? I am a total novice at this.
