Issue in Converting Area chart to Pie

Hi All,

I have a table with Columns as "Demand" and "Receipts" for each day, from which "Pending Collections" (= Demand - Receipts) is calculation in another column.

After summarising, Since all these are columns and a PIE visualisation needs data points to be in rows i am not able to visualise same in a pie

Current data format (tabular view)

Collections Pending Collections
5000 15000

Needed Data Format
Collections 5000
Pending Collections 15000

Hi @Chandra
Metabase currently does not have a way to transpose the data. You would have to do that in SQL.
https://github.com/metabase/metabase/issues/3769 - upvote by clicking :+1: on the first post