-
Conditional Charts in the Dashboard
I would like to display a KPI if a condition is true ([boolean field] = true). Scenario: I have a helper sheet checking data entries for errors and a second helper sheet counting the errors. I would like to display a KPI on the dashboard showing the count of errors only if errors exist. The KPI then points to a report that…
-
Dashboard Bar Chart from One Row of Data
I am working on a dashboard (newbie) where I have a table of data in my metric sheet but I need to graph each row independently in a bar chart. My challenge is that, after the first row, I get multiple rows of data displayed in my bar chart when I window the headings and the row(s). How do you choose the row from the range…
-
Need formula & function for the question below
If I apply for PTO, I want to make sure it's getting subtracted from the "WR Balance Before Application" and it would be straight subtraction selecting cells & it's sorted. The main formula I am looking for is, If I apply again, my "WR Balance Before Application" should be the latest "WR Balance Left After Application"…
-
PDF link in dashboard
It would be nice that a PDF can be dragged and posted to the dashboard. thanks!
-
How to create a dashboard to show increases
I need to track the cost impact of changes per community. We track changes using a CRF # - so for example if I have CRF # 2024-015 that effects two communities, I would like to be able to say "hey, CRF 2024-015 creates a cost change at San Tan 40's Electrical Contract by $589.50 or 13% AND it also creates a cost change at…
-
Can multiple users use the same sheet without causing changes for other users?
Sorry if my question is unclear. Here's what I'm getting at: I have an onboarding training checklist I made for all new hires. Each new hire has their own individual dashboard. Basically, I want to add the general onboarding checklist (which is a sheet) to each employee's dashboard. However, I want to know if there is a…
-
Cannot deselect "All Columns" in the Columns Included when creating a dashboard from a report
When I click on the x to remove All Columns to select which columns I want included in the chart it will not be removed. Also, when I try to add columns in addition to All COlumns being selected it provides an error- I am trying to build a chart widget that shows a "column" or bar chart breakdown of the count of items by…
-
Metric sheet filter for Dashboarding
Hello: I have a Metric Sheet that I use to feed data into a stacked column graph in the dashboard. The Metric Sheet has rows and rows of data each with a Totals column. For those rows with 0 in the Totals, I exclude them in the data for the stacked column graph. I've tried to apply a filter which removes the 0's so that…
-
Customizing the minimum and maximum values on the bar graph in the Dashboard
I am preparing several bar graphs in the Dashboard but the minimum and maximum values vary depending on the graphs. In my case, I want to set 0% as the minimum and 100% as the maximum value. I asked the technical support center but learned that there is no feature in the Dashboard. Please join me in requesting a useful…
-
Web Widget for Notes
I am looking for a 3rd party note-taking site to use as a web widget on a dashboard. I was previously using a Rich Text widget on the app and calling it the "Bulletin" but this is clunky. In order to add/ edit text on this bulletin, we have to "edit" the dashboard and click save. I want it to be edited easily. There has to…
