GitHub user muku edited a discussion: Sunburst chart remove row from case-when query results
Might be elementary level but I'm struggling with filtering my results in a sunburst chart. In the hierarchy query, I have a custom SQL clause like this: `CASE WHEN text like '%val1% ' THEN 'Val1' WHEN text like '%val2%' THEN 'Val2' END` The metric is Count. I also apply a custom where SQL clause to filter the results based on a date column. The problem with that is that it. returns my Val1 & Val2 records plus one more row with all the records that don't contain val1 and val2 in the text column. Is there a way to remove that unwanted row? GitHub link: https://github.com/apache/superset/discussions/32895 ---- 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]
