Function "SUM" doesn't support SUM(TEXT)

Looker Q&A Looker Studio
,
1

I have some fairly basic csv data that I am using Looker Studio to present.

Each week I add a new csv file to my data set. So far I have the below:

mbarnes106_0-1719304383430.png
mbarnes106_0-1719304383430.png1576×204 13.2 KB

Each csv file has a column with a date and the reports are set to look at last weeks data.

I have just uploaded the wk34 data and i get this on all charts:

mbarnes106_1-1719304518407.png
mbarnes106_1-1719304518407.png1257×465 58.2 KB

When looking at why I think its down to calculated field which causes a problem.

mbarnes106_2-1719304584005.png
mbarnes106_2-1719304584005.png832×385 11.3 KB

It shows “SUM” doesnt support SUM(TEXT)

but I am summing “stocked” which is a column with either a 1’s or a 0’s in it.

mbarnes106_3-1719304684786.png
mbarnes106_3-1719304684786.png826×485 23.7 KB

The report all worked fine last week so I am trying to work out how this could happen. The most recent data I have uploaded has a column heading and then just has 1’s or 0’s in it

2

Have you checked the CSV for mixed data types? This wouldn’t be an uncommon root cause of an issue like this.

Also, if there has been an update since you wrote the metric, you may need to add a space to trick LS into thinking you changed it in order for it to recalculate.