I have a worksheet which feeds a widget on a dashboard, and I generally only check it once a month. It worked last month (and has for the past year) but it stopped working recently.
I am using it to find the average order value in a given month to track m/m changes.
The data I am pulling from uses timestamps. The worksheet has always been fine converting the timestamp to a date, so that I could limit it to only show me transactions in the most recent complete month.
I went to pull the data for my report today, and the worksheet no longer works. I get the error “Error
cannot cast type bigint to timestamp with time zone”. Nothing has changed since last month, it simply no longer works. The worksheet wont pull any data.
If I take that column and unconvert it, the worksheet loads. but I need it converted to dates, so that I can limit the view to the most recent complete month.
Has anyone else had this happen to them recently, or know a work around?