A question with conditional tables and colors.

[mistersister]

Hi,
so I have this non-pivot table with a column that has an aggregate for the margins of different clients, expressed as a %.

Now, I have set the conditional formatting such as if Margin > 0, color the cell in green and if Margin < 0 color in red which works, but the problem is that because we have some very high numbers both positive and negative, the highest margins will appear in an intense shade of green/red that will go down to white as it reaches 0.

Is there any way to set the starting color as a different shade of red/green instead of white? I want to avoid my columns looking like this:

[dosubot[bot]]

Hello @mistersister! I'm here to help you out while you wait for a human maintainer. Whether it's solving bugs, answering questions, or becoming a contributor, I've got your back!

I couldn't find a specific solution for modifying the starting color of a gradient in Apache Superset's conditional formatting settings. However, you might want to explore the setupColors.ts file in the superset-frontend/src/setup directory, which provides a mechanism to register and customize color schemes. This could potentially allow you to define custom color gradients for your visualizations ^[1].

Additionally, there is a similar closed issue regarding conditional formatting, but no solution was found in the comments. You can view it here ^[2].

To reply, just mention @dosu.

---

Docs are dead. Just use Dosu.