leandroneckel commented on issue #34784: URL: https://github.com/apache/superset/issues/34784#issuecomment-3760087827
> I'm not sure if this will help, but adding an SQL expression directly from the chart editor works with ClickHouse. I'm no expert on both Python and Superset code, but I think this issue occurs when calculated columns are injected into the final query (the expression is missing). It may be a templating issue or something similar. If someone could point out where this happens in the code, I'll try to take a look. > <img alt="Image" width="359" height="333" src="https://private-user-images.githubusercontent.com/3306862/536809392-4fae1a70-3e03-4130-b056-83cb5fd2a30d.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Njg1NzEyOTcsIm5iZiI6MTc2ODU3MDk5NywicGF0aCI6Ii8zMzA2ODYyLzUzNjgwOTM5Mi00ZmFlMWE3MC0zZTAzLTQxMzAtYjA1Ni04M2NiNWZkMmEzMGQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDExNiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjAxMTZUMTM0MzE3WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9OTg1MDdkZTQzYmYzMjFiZjIyZjI0ODFmODM2ZDA5OTBhNmJiMTBlZDYzZmI4ZGNhNjQ1NDYyMDhkMTVjOTE0ZSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.GIeCWMK-rTr1nEI_AhH-qJppSjWVQ0GRUOb--4tFerE";> The issue with creating calculated columns at the visual level rather than the dataset level is that cross-filters will not function correctly. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
![https://private-user-images.githubusercontent.com/3306862/536809392-4fae1a70-3e03-4130-b056-83cb5fd2a30d.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Njg1NzEyOTcsIm5iZiI6MTc2ODU3MDk5NywicGF0aCI6Ii8zMzA2ODYyLzUzNjgwOTM5Mi00ZmFlMWE3MC0zZTAzLTQxMzAtYjA1Ni04M2NiNWZkMmEzMGQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDExNiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjAxMTZUMTM0MzE3WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9OTg1MDdkZTQzYmYzMjFiZjIyZjI0ODFmODM2ZDA5OTBhNmJiMTBlZDYzZmI4ZGNhNjQ1NDYyMDhkMTVjOTE0ZSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.GIeCWMK-rTr1nEI_AhH-qJppSjWVQ0GRUOb--4tFerE"](https://private-user-images.githubusercontent.com/3306862/536809392-4fae1a70-3e03-4130-b056-83cb5fd2a30d.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Njg1NzEyOTcsIm5iZiI6MTc2ODU3MDk5NywicGF0aCI6Ii8zMzA2ODYyLzUzNjgwOTM5Mi00ZmFlMWE3MC0zZTAzLTQxMzAtYjA1Ni04M2NiNWZkMmEzMGQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDExNiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjAxMTZUMTM0MzE3WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9OTg1MDdkZTQzYmYzMjFiZjIyZjI0ODFmODM2ZDA5OTBhNmJiMTBlZDYzZmI4ZGNhNjQ1NDYyMDhkMTVjOTE0ZSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.GIeCWMK-rTr1nEI_AhH-qJppSjWVQ0GRUOb--4tFerE"){kind=link}