-
Stacked Bar Chart Label Issue
Hello, I'm having issues showing data labels on a stacked bar graph. I can get the labels to appear on a regular bar graph (left) but when I stack them (right), I only get data labels for the last row. Any idea why this is happening? I thought it was only showing positive %s but noticed there would be a 10% in the middle…
-
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.