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!!
Report widget not showing available reports
On our app home page, when I try to update an existing report using the widget, or add a new report using the widget, our reports are not showing up in the report dropdown. Even the report that was already previously added via the widget is not showing up in the report dropdown. I am the app manager and have administrator access. We have a number of existing reports for this table, and several are used on the app home page, and have been there for at least a year. All are shared reports with no access restrictions. They are not grid-edit reports. I have not made any changes to the type or location of our reports. I have 3 apps where I'm the manager/administrator, and the issue is happening with all of them. How do I make them show up again? And could this be tied to the recent QB update that changed some UI (tables now listed in a left sidebar instead of on top, etc.)? This is the first time I've tried to change reports since that UI update. Thank you for your help! These are the reports as shown from the table page: This is what I see in edit mode on the home page. These 2 items are the only things that show up and neither are clickable and a search does not find the reports:
Summary Reports
Y'all have been so helpful! I'm hoping I can figure this one out! I need to create a summary report that shows 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!
Merging Two Completely Different Tables
Greetings, I couldn't delete this post so, I am just completely modifying it, for anyone who navigated their way back to this and is thinking, "This isn't what I was looking for". lol I have two tables with completely different data. I want to create a third table which would be made up of the contents of each record in table1, duplicated for each record in table2, so I can add additional formulas, etc for a report. table1 structure Name -- StartDate -- FinishDate -- Amount table2 structure Period -- BeginDate -- EndDate Desired merger Name -- StartDate -- FinishDate -- Amount -- Period -- BeginDate -- EndDate --... Example output Name1 -- StartDate -- FinishDate -- Amount -- Period1 -- BeginDate -- EndDate --... Name1 -- StartDate -- FinishDate -- Amount -- Period2 -- BeginDate -- EndDate --... Name1 -- StartDate -- FinishDate -- Amount -- Period3 -- BeginDate -- EndDate --... Name2 -- StartDate -- FinishDate -- Amount -- Period1 -- BeginDate -- EndDate --... Name2 -- StartDate -- FinishDate -- Amount -- Period2 -- BeginDate -- EndDate --... Name2 -- StartDate -- FinishDate -- Amount -- Period3 -- BeginDate -- EndDate --... etc... The true challenge with this is being able to set this up so the merger of the data in this fashion happens dynamically. Meaning when one or both tables has a record added, modified, or removed, the merged output reflects the changes. I figure this calls for a relationship, especially for the dynamic aspect of things. However, I don't know how to set that up, assuming it's possible to do. If anyone has any suggestions, that would be greatly appreciated. Thank you in advance.
