Coloring / highlighting rows and exporting in Excel

tomtom
tomtom Registered Posts: 21 ✭✭✭✭
Hello,

It would be nice to have a plugin that allows to color rows based on a formula or criteria, and to have the color / highlight kept when exporting to an Excel file.

Best regards.

Answers

  • Ferdma
    Ferdma Dataiker, Registered Posts: 2 Dataiker

    Hello Tomtom,

    Not sure if such plugin could be easily implemented but what you can do right now is the following :

    - In a prepare recipe, add a column to flag the color you want that row to have based on a formula step or a flag step (lets say that is your 6th column and it contains 'RED')

    - Export to Excel

    - In excel, use conditionnal formatting based of a formula to color the whole line based on your 6th column (Col F), see here for how to build such formula in excel : https://trumpexcel.com/highlight-rows-based-on-cell-value/

    You formula should look like '=$F1="RED"'

    Hope it helps !

  • t0mt0m
    t0mt0m Registered Posts: 4 ✭✭✭✭

    Having, in DSS (prepare recipe for instance), a right-click "Color <color> lines containing '<pattern>' in this column" would be great.
    There's already a "highlight" feature but it doesn't cover Excel exports.

  • Ashley
    Ashley Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 163 Dataiker

    Hi @tomtom
    ,

    With the release of 12.5, you can now format rows in an Explore based on their values and preserve that formatting when you export the dataset as an Excel file or publish it to a dashboard.

    To apply conditional formatting, open an Explore, select the column menu, and go to Conditional Formatting > Color by rules. Once applied, you can also apply the color to the entire row by clicking on the column summary bar.

    Screenshot 2024-02-26 at 09.41.04.png

    Cheers,

    Ashley

  • tomtom2
    tomtom2 Registered Posts: 6

    Thanks you rock !

Setup Info
    Tags
      Help me…