unable to select report data for chart

Trezbo

Hi, I have generated my report based on resources, accounts and project status which I am trying to create a chart for but it won't accept the data from the report - any ideas?

Vivienne Strettle

Hi Trezbo. It doesn't look as if there are any metrics in the data. What are you trying to chart?

Viv

Trezbo

Ah I was trying to use the chart to show the number of different Project Status by TPM but I'm guessing ill need to use a formula to COUNT that up first rather than pulling from a report to be able to leverage that via the chart widget?

Genevieve P.

Hi @Trezbo

You are correct! You can create a second, separate rollup sheet for the chart, and using cross-sheet references you can use a COUNTIF formula to create different Counts by Project Status. Let us know if you need help with this.

Cheers!

Genevieve