Non numerical data error on graph

I am putting together a shift rota, and trying to pull data off the rota into a graph.

This is the data, a summary of each day by team to work out a percentage of each team that are in/out on any given day etc.

If you see towards the bottom where the cell is selected there are two rows.

Percent OFF & Date. This is what I want to graph.

So I have this data in a report for the entire year and filtered by the 'Data Tag' column so it only shows 'Bushing OFF' & 'Bushing Data'.

Then I have created a dashboard and tried to import the data into a graph. I get this error:

The data is all in a Drop down column format, but as far as I'm aware that's an acceptable format for graphs. I've tried with and without percentage.

Weirdly it worked fine the first time I did it, but not now.

Can anyone help unpick what's going on here?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!