Would be awesome if we could use the Single Value Chart with pivoted data. Right now the following error is shown when trying to do this.
Here's what my data looks like. I'm using table calculations with pivot_where's to calculate a final "status", which I'd like to visualize as a single value chart. Any chance this could be suggested to your product team?