I have a model that includes a count of “stacks” completed per team. each team has a goal to complete a number stacks.
how do I think about making a chart that shows progress to the goal. For example, I can make a table like this:
team completed target
team 1 20 500
team 2 35 550
team 3 52 100
team 4 180 5000
I want to show the target as a reference on a chart that visualizes team progress to the goal during an event. The pivot table is easy to setup, but the chart is eluding me. Either I’m missing some measures, or not reading visualizations properly
this sort of approximates what I mean using bar chart w/ a reference line. The reference line is limited b/c it’s a single value for the entire pool. I’d like to get a bar per team and show each teams individual goal.:
My first choice for this would be the Combination Chart visualization type. You can plot the target value as a line and the completed values as bars/columns.
Or you could plot pairs of bars/columns next to each other, like this:
And another option would be to calculate the % completed and plot that instead of plotting both completed and target. This will show relative progress better because the targets are so different – 100 vs. 5000.
I ended up calculating the remaining volume and charting it in a variety of ways. we also know the per hour volume, so I created a days remaining forecast (sorted by slowest) like this:
