-
Automation for ever-changing database
The company I'm working for has a database that houses info for our external clients, the database is constantly being updated nearly daily, I want to create visuals on a dashboard for various statistics based off the columns of information. I used =countif and it worked well for some columns, but I quickly ran into an…
-
Dashboards and Reports
I'm building a Project Office (PMO) with 80 projects and looking to build a project dashboard for all 80 projects. We would need 4 reports per project (project summary info, project plan, issue/risk log, and project contact list). I'd rather not develop 320 reports (80 projects x 4 reports). Is there a way to do this more…
-
How can I automatically remove data with a value of zero from a Dashboard
I am looking for a formula to remove any line of data that has a value of zero in the Report, from the Dashboard. So, when the line of data is zero in the Report, it should eliminate that row from the Dashboard.
-
Amount vs % toggle button in published dash
Hello all, The title basicly says it all. Would love to be able to toggle between amounts and percentages in a published dash, just as in the edit-mode of a dash (last screenshot). Didn't actually know it was there -toggle between amount and % that is- made the formula in sheetsummary manually for every category, turns out…
-
Published Dashboard Appearing Very Zoomed in on Moblie
Have a dashboard we have been using for over 3 years without issue - now when uses go to use the dashboard on a mobile device the dashboard is very zoomed in and have to scroll side to side to select options - this is a new issue with all dashboards on mobile devices
-
Can you create a chart on a dashboard with blank rows?
I have a metric that will report, month over month, new values as they are calculated and added to a sheet. There is an automation that runs each month to copy the current metric row, and place it in a historical sheet. The challenge is that the chart must be re-configured every month to include the new row. Is there any…
-
Why can't I change the project name on the dashboard?
I am a new customer with the Pro plan but I am unable to change the Project Name on the Dashboard. It reads "Project Name in Summary Sheet", so I go to the Summary Sheet and it is grayed out with no option to edit. Please don't tell me I need to pay more to change the Project Name.
-
Support for Expand/Collapse in for a Grouped Report Embedded in a Dashboard
I have a report with groupings. Whether or not those groupings are set to be expanded or collapsed in the report, when I embed that report in a dashboard the report is fully expanded. And there is no way to collapse it in the dashboard. The expand/collapse arrows are missing. There is a Collapse Grouped Report setting in…
-
Charts - reporting on two 'Counts'
Hi, My company is logging Fire Risk Assessment actions, and we want to see a chart that shows: Actions by priority and then within that: Actions by 'complete'. So, for example, we want to see that there are 46 Minor actions, 19 of which are 'complete' (a checkbox), 144 Moderate actions, 130 of which are 'complete', etc. At…
-
Dashboard Sharing Best Practice
I've have a 3-tiered solution, with projects nested within programs, and programs within a single portfolio, all managed by control centre. At the portfolio level, there's a unified dashboard, providing the ability to navigate to any of the six program-level dashboards. Each program-level dashboard then presents multiple…