Partial color fill in one of the column in a iGrid

[Former Member]

Hi,

Is there any way to set one of the column in a grid partially filled with a color.

Eg:- 75% of a cell in a column should filled ( horizontally ) with a color if the value of the column is 75 and other columns are data columns.

I may be asking too much. But I am wondering is it really possible in xMII 11.5 and/or 12.x.

Thanks in advance.

Srinivas.

[Former Member · Accepted solution]

There are also a few tricks that you could use to achieve this:

First approach:

Fill 10 virtual column values with a specific character or a space. Depending on the font, you could use something as simple as an asterisk (*) for the BlockChar or a more "exotic" character code.

- Use a BLS query to add 10 "calculated" columns to the actual data query, and use expressions such as:

VirtualColumn0: stringif(ColumnValue >= 10,BlockChar," ")

VirtualColumn1: stringif(ColumnValue >= 20,BlockChar," ")

...

VirtualColumn9: stringif(ColumnValue >= 100,BlockChar," ")

- Define your iGrid and point it to the BLS query instead of the actual data query, and set the column headings in the "virtual columns" to a blank or dash

Second approach:

Basically the same as the first approach, but with one virtual column, and have your calculated column expression look like below (with nested stringifs):

VirtualColumn: stringif(ColumnValue >= 10,"",stringif(ColumnValue >= 20,"",stringif(ColumnValue >= 30,"*"....stringif(ColumnValue >= 100,"*********","")

[Former Member · Accepted solution]

Rick,

Thank you very much. I think this virtual column approach is good as we achieve it with in display template itself instead of writing in scripting this logic at client side page level.

I think my question is answered and I want to award points but some how I could find radio buttons to do so which I used to see earlier beside every reply and mark as answered.

Thanks,

Srinivas.