You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "edison-lhk (via GitHub)" <gi...@apache.org> on 2025/09/24 17:14:28 UTC
[D] Conditional formatting improvements [superset]
GitHub user edison-lhk created a discussion: Conditional formatting improvements
## Description
I recently tried to apply conditional formatting to a table in Superset and found myself longing for the following:
1. The ability to apply conditional formatting to non-numeric columns (specifically text and boolean columns).
2. The ability to toggle highlighting for an entire row instead of just an individual cell.
discussions link: https://github.com/apache/superset/discussions/22790?sort=new
GitHub link: https://github.com/apache/superset/discussions/35269
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk added a comment to the discussion: Conditional formatting improvements
Hi @rusackas, I am Edison, a 4th year student at UTSC CS. I am working with my teammates @Morilili, @mohammadqassim12, and @jasonl-18, who are also 4th year students at UTSC CS. We would like to take the initiative to work on improving conditional formatting in the Superset table based on the idea suggested in discussions https://github.com/apache/superset/discussions/22790 and are willing to open a PR for this.
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14501512
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk edited a discussion: Conditional formatting improvements
## Description
Based on the discussion link https://github.com/apache/superset/discussions/22790?sort=new, these are some of the improvements that can be made for conditional formatting in Superset table:
1. Add support for applying conditional formatting to boolean columns
2. Add a flag to switch from a color gradient to the color itself without using a gradient
3. Enable selection of a color scheme from the color palette (considering that the table also includes a time comparison)
GitHub link: https://github.com/apache/superset/discussions/35269
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk edited a comment on the discussion: Conditional formatting improvements
@SBIN2010 Thanks for the reply, appreciate it! These sounds like some good tasks that we can work on!
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14515757
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk added a comment to the discussion: Conditional formatting improvements
@rusackas Sorry Evan, just tagging you again so that we can make sure that we can start working on this idea!
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14608694
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk added a comment to the discussion: Conditional formatting improvements
Here are some good references for our issues: https://github.com/apache/superset/pull/34330 and https://github.com/apache/superset/pull/34762
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14618985
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk edited a discussion: Conditional formatting improvements
## Description
Based on the discussion link https://github.com/apache/superset/discussions/22790?sort=new, these are some of the improvements that can be made for conditional formatting in Superset table:
1. Add support for applying conditional formatting to boolean columns (`is true`, `is false`, `is null`, `is not null`, etc)
2. Add a flag to switch from a color gradient to the color itself without using a gradient
3. Enable selection of a color scheme from the color palette (considering that the table also includes a time comparison)
GitHub link: https://github.com/apache/superset/discussions/35269
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk added a comment to the discussion: Conditional formatting improvements
@SBIN2010 and @rusackas Thanks for all the comments! Since this issue is taken already, our teammates and I are planning to look for alternatives now, will follow up later! Also, this ideas actually already existed in https://github.com/apache/superset/discussions/22790, should I closed this ideas instead?
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14501631
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk edited a discussion: Conditional formatting improvements
## Description
Based on the discussion link https://github.com/apache/superset/discussions/22790?sort=new, these are some of the improvements that can be made for conditional formatting in Superset table:
1. Add support for applying conditional formatting to boolean columns
2. Add a flag to switch from a color gradient to the color itself without using a gradient
3. Enable selection of a color scheme from the color palette (considering that the table also includes a time comparison)
GitHub link: https://github.com/apache/superset/discussions/35269
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk added a comment to the discussion: Conditional formatting improvements
@SBIN2010 Awesome, what will be the remaining tasks we can work on regarding this topic? Since it will be a university course's group project for our team, we will need to define a complete issue or task to work on!
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14503898
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
GitHub user rusackas added a comment to the discussion: Conditional formatting improvements
These are fine ideas, and we welcome the improvements here! I'll move this to an "Ideas" Discussion since it's not a bug, _per se_, but we appreciate any further discussion/collaboration on the idea, and will be happy to review any PRs here. Hi to everyone at UTSC by the way, looking forward to further collaboration!
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14501514
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "SBIN2010 (via GitHub)" <gi...@apache.org>.
GitHub user SBIN2010 added a comment to the discussion: Conditional formatting improvements
This topic is not occupied, I just started developing it, but you can also develop it, any ideas, discussions about implementation are welcome.
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14502009
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk edited a comment on the discussion: Conditional formatting improvements
@rusackas Sorry Evan, just tagging you again so that we can make sure that we can start working on this idea! Thank you
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14608694
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "SBIN2010 (via GitHub)" <gi...@apache.org>.
GitHub user SBIN2010 added a comment to the discussion: Conditional formatting improvements
Hi @edison-lhk!
The implementation of this has already begun in #34330 and continues on #34762
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14501513
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk edited a discussion: Conditional formatting improvements
## Description
Based on the discussion link https://github.com/apache/superset/discussions/22790?sort=new, These are some of the improvements that can be made for conditional formatting in Superset table:
1. Add support for applying conditional formatting to boolean columns
2. Add a flag to switch from a color gradient to the color itself without using a gradient
3. Enable selection of a color scheme from the color palette (considering that the table also includes a time comparison)
GitHub link: https://github.com/apache/superset/discussions/35269
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk edited a discussion: Conditional formatting improvements
## Description
Based on the discussion link https://github.com/apache/superset/discussions/22790?sort=new, these are some of the improvements that can be made for conditional formatting in Superset table:
1. Add support for applying conditional formatting to boolean columns
2. Add a flag to switch from a color gradient to the color itself without using a gradient
GitHub link: https://github.com/apache/superset/discussions/35269
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk deleted a comment on the discussion: Conditional formatting improvements
@rusackas Sorry Evan, just tagging you again so that we can make sure that we can start working on this idea! Thank you
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14608694
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "SBIN2010 (via GitHub)" <gi...@apache.org>.
GitHub user SBIN2010 added a comment to the discussion: Conditional formatting improvements
> @SBIN2010 Awesome, what will be the remaining tasks we can work on regarding this topic? Since it will be a university course's group project for our team, we will need to define a complete issue or task to work on!
For example:
1) Add support for applying conditional formatting to boolean columns
2) Add a flag to switch from a color gradient to the color itself without using a gradient
3) Enable selection of a color scheme from the color palette (considering that the table also includes a time comparison)
First, I see improvements to this functionality.
@rusackas What can you say about the development of this functionality?
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14515722
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk added a comment to the discussion: Conditional formatting improvements
@SBIN2010 Thanks for the reply, appreciate it! These sounds like some good tasks that we can work on, if these sounds good to Evan @rusackas as well, we can start work on them! We just need to redefine the scope and tasks for this discussions idea before starting!
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14515757
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk edited a discussion: Conditional formatting improvements
## Description
Based on the discussion link https://github.com/apache/superset/discussions/22790?sort=new, these are some of the improvements that can be made for conditional formatting in Superset table:
1. Add support for applying conditional formatting to boolean columns ("is true", "is false", "is null", "is not null", etc)
2. Add a flag to switch from a color gradient to the color itself without using a gradient
3. Enable selection of a color scheme from the color palette (considering that the table also includes a time comparison)
GitHub link: https://github.com/apache/superset/discussions/35269
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Conditional formatting improvements [superset]
Posted by "edison-lhk (via GitHub)" <gi...@apache.org>.
GitHub user edison-lhk added a comment to the discussion: Conditional formatting improvements
@rusackas Hey Evan, as per the project requirement, we would like to share our purposed solution regarding to the issue to get some feedback!
For feature 1 (Add support for applying conditional formatting to boolean columns), we propose extending conditional formatting to support boolean fields. When a boolean column is selected, the rule editor will show type-specific operators — `is true`, `is false`, `is null`, and `is not null` — and hide options for other data types. Boolean rules are evaluated as categorical predicates (`true`/`false`/`null`) and apply a fixed color directly without gradients or thresholds.
The change includes:
1. ensuring boolean columns appear in the column picker wherever conditional formatting is configured
2. scoping operators by column type so only valid choices are shown
3. coloring the cell whenever its value satisfies the rule
4. keeping full backward compatibility so existing tables are unchanged unless a boolean rule is added.
For feature 2 (Add a flag to switch from a color gradient to the color itself without using a gradient), in order to address improving customization for colour formatting using fixed colours, we propose adding a boolean `useGradient` flag to conditional formatting to complement the current gradient-only approach. When `useGradient` is true (default), behaviour remains unchanged; when false, rules apply a fixed (solid) color at full opacity with no interpolation, improving readability for categorical/discrete data and for cases where clear thresholds or outliers need crisp highlighting.
The change includes:
1. adding `useGradient` to `ConditionalFormattingConfig` (default `true` for backward compatibility)
2. a checkbox in the UI to toggle it
3. updating colour computation to skip opacity calculations when disabled.
We’d really appreciate any feedback or suggestions you might have!
GitHub link: https://github.com/apache/superset/discussions/35269#discussioncomment-14652283
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org