Creating a chart for number of hours scheduled per day

Hello,
I have a table with the following columns
Date
Resource
Estimated Duration
How do I create a chart with Estimated Duration on the Y and Date on the X.

In this case the Resource and Date Could be repeated on several rows.
I would like to show for a resource, the total number of estimated durations per date for each resourceโ€ฆ

I have tried selecting Column seriesโ€ฆ but only the estimated duration is showing up and not the date is there something that am missing?

I have also created a slice to isolate data for each resourceโ€ฆ but now how do create the column chart with sum of estimated duration per date and display date on x axis and Estimated Duration on the y axis.

1 0 246
  • UX
0 REPLIES 0
Top Labels in this Space