I am trying to create a simple doughnut chart which uses two columns which can easily be written in SQL as the following
SELECT 'CAR' as 'TYPE', SUM(carCount) as 'Count' from table UNION ALL SELECT 'TRUCK' as 'TYPE', SUM(truckCount) as 'Count' from table
I am currently reading from a CSV file. How should I approach this problem, as it currently doesn’t seem possible to use multiple columns in a doughnut/pie chart? I’m having similar issues with other timeseries data.