Hello,
I'm trying to create a dynamic Pie chart based on user input using the input variable.
I created a SQL query as follows
SELECT {{filtervalue1}}, count(*)
FROM Tablename
WHERE --condition
GROUP BY {{filtervalue1}}
ORDER BY {{filtervalue1}} ASC
I expect the user to input the column name as the users are technical users. But the above doesn't work. The filtervalue1 was created as a text variable. Based on the user input which should be a column name the sql result should show count of different categories in that column but what I get is as below.
Not sure where is the mistake
on the first post