search

apache / superset

Apache Superset is a Data Visualization and Data Exploration Platform
https://superset.apache.org/
Apache License 2.0
62.06k stars 13.61k forks source link

Can't use cross-filtering on a column from a table whose name has been overidden #24836

Open martin-raymond opened 1 year ago

martin-raymond commented 1 year ago

cross_filter_works.mp4 shows that you can cross filter the dashboard by choosing a line from the column 'filArianeContenu' from the table 'Liste de tous les éléments consultés (site courant)'

But, when you overide the name of a column to have a more user-friendly name 'A specific name user friendly', cross_filter_does_not_work.mp4 shows that cross-filtering does not work properly.

Environment

https://github.com/apache/superset/assets/10060967/746bdbe5-19de-49d4-850b-25081dfe86b4

https://github.com/apache/superset/assets/10060967/8e19a19f-ac16-4f9c-a48e-5ab60086abbf

michael-s-molina commented 1 year ago

@rusackas Who's the best person to investigate this issue?

martin-raymond commented 8 months ago

@rusackas did you find that person ?

rusackas commented 8 months ago

Nope! Not sure who that would be, but it seems the videos don't work here. If anyone can update this thread (or file a new issue) with a reproducible use case (preferably using example data/dashboards) that would be immensely helpful.

rusackas commented 8 months ago

Spoke too soon. The videos just took forever to load. I'm not sure if this is the priority list for anyone at the moment, unless @yousoph knows otherwise. If anyone wants to investigate and open a PR, it would be hugely appreciated.

fmannhardt commented 6 months ago

I was encountering the same issue right now and it is very annoying when using tables. Just a thought on fixing this, maybe instead of renaming the columns (in SQL) to have them show user friendly in the UI, the table widget could be extended to allow for a UI only change in the "Customize column".

I understand that the philosophy is somehow keep things close to SQL but I think technical identifiers and what is shown to the user may be very different and, sometimes, maybe different charts would show the same technical column with a different name but still want to cross filter on them.