GQI – Cannot Apply Conditional Coloring to Columns That Have Been Manipulated

Solved1.05K viewsColumn Manipulation conditional coloring Dashboards GQI
1
0 Comments

Hello All,

I am attempting to apply conditional coloring to various columns that I've aggregated via GQI. I don't have any issues if the columns are untouched after getting parameter data. However, it does not seem possible to apply conditional coloring to columns that have had their names changed via Column manipulation. Below are pictures showing what I am experiencing.

Is this behavior expected? Are there known workarounds to applying conditional coloring while maintaining the new column names?

Thank you in advance.

Thomas Rich [SLC] [DevOps Advocate] Selected answer as best 15th October 2023

1 Answer

5
18.56K 3 Comments

Hi Thomas,

It is expected behavior. When you use column manipulation, the new column will be a string column. Currently the only workaround is to use a GQI custom operator to rename these columns.

Hope it helps.

Thomas Rich [SLC] [DevOps Advocate] Posted new comment 16th October 2023
Thomas Rich [SLC] [DevOps Advocate] commented

Thank you Miguel, that is a great idea. I will give that a shot.
Ward Haeck [SLC] [DevOps Enabler] commented

Hi Thomas, just wanted to mention that there is already a custom operator on Github to rename a column: https://github.com/SkylineCommunications/SLC-GQIO-RenameColumn
Best regards, Ward
Thomas Rich [SLC] [DevOps Advocate] commented

Thank you very much Ward. This operator works really well and accomplishes exactly what I was looking for. If even goes a step further and doesn’t create a new column but instead just replaces the original.