I have projects that are being completed and assigned a completed date. I have a column named "Levels" to filter to the data I want to track. I would like a graph that charts the total number of "Level 2" completions over time. The way I picture this is a bar chart. The bar has two sections: 1. Everything accumulated…
Hello, I want to calculate the total time spent by each user to then create a graph. I tried a formula but it does not work. Can you help?
Hello, I am trying to create a chart that shows the financial impact on a community when a change is made. Here's the backstory - I am in homebuilding and any time there is a change at a community, we associate that change with a CRF #. I would like to be able to create something that shows the change in dollar amounts per…
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…
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…
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…
I'm trying to not have the values not have decimal places. Also im trying to have the min value of the y axis to 80% and not 95%. How would i do it?
I’ve built out an Error Tracking Mastersheet and I’m now trying to roll the metrics up but I’m struggling a bit. There are 4 types of errors that can be made (DE, CE, LE, EE). There are close to 20 people, but for the example below I only show 3. Each person is their own Drop down column with the same 4 error types. Each…
The ability to easily transform numerical data on dashboard graphics. I.e. 1.5M, instead of the long string of numbers, when adding labels to graphs, so that it is clearer to read.
This discussion has been merged.