Gauge Visualization Error for no discernible reason

1

Hello! Thanks so much in advance.
I'm pulling my hair out with the Gauge visualization. I have a self-hosted Metabase on the latest version.
I'm pulling data with my query just fine and it's creating a count as shown in the image below.
image

Now, if I switch over to the Gauge visualization I get an error.
image

Can anybody guide me on what is going on? I would figure a count is a number! If I change it to say, Pie, it shows the 30 Total just fine with the pie chart.

Thanks!

2

Got it fixed. Apparently all I had to do was create one more filter on a column that wasn't a datetime column. I just filtered on my lead_id as not empty and then the visualization worked like a charm.

3

Yes so a Gauge would expect a value in your case it was getting a Date

4

Thanks! I guess I was just thinking it was only evaluating the count of those rows, not the actual format of the column type.