I'm trying to show the sum of data from a column in a Google Sheet. The scorecard that I am using is attached to blended data, as I need to be able to do a calculation with some other fields, but before that I need to get it to even show the sum of a certain column properly.

I need it to show only today's sum, so I have added timestamp and set it to today, but when I do this, it shows 0 when I know for a fact that there is more like 150 in this column for the day.

For reference, I have attached my blended data source below. I have already tried changing the order of the sources and adding or removing timestamp from both the Join Keys and Date Range fields.enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.