-
Template Formatting For Graphs - Consistent Colors
Is there a way to keep the colors consistent for graphs. For example, I created a graph showing units by color, with columns. Right next to it, I created a pie chart using the same source data but the colors for each unit represented are different. I know I can change them to match, but what a pain to do this for all my…
-
Showing Cumulative Work Completed Over Time
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…
-
Time Spent /Formula
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?
-
How do I report cost changes?
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…
-
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…
-
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…
-
Max/Min Axis Value on graph
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?
-
Cross Sheet Countifs multiple columns
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…
-
Transforming numerical data
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.
