GitHub user Aruneem edited a comment on the discussion: Custom Sql query Problem
Let me Reframe this question and make it more simple 1) In my dataset you can see that Metformin has appeared twice , you in custom sql cannot hardcode it by mentioning Metformin , because in actual dataset there are various Brands that are appearing multiple times ,so SUM(CASE WHEN Brand = 'Metformin' THEN Sales ELSE 0 END) cannot be applied. 2) Query that i need to provide is at the custom sql level , that is at the chart level , without changing anything in the actual database, so queries like select * from .. is not allowed because such queries are written at the database level not at the custom sql level. GitHub link: https://github.com/apache/superset/discussions/40045#discussioncomment-16899958 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
