cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

create one table with different style in the same column due to different targets

Islam_Amer
6-Contributor

create one table with different style in the same column due to different targets

Hello All

 

I have one table with different targets i want color each cell with the right target if in or out

I have try but the grid give me only one style for the column , 

Do you have any Idea how it work?

 

 exa.PNG


 

7 REPLIES 7

In Grid widget is allows RowFormat setting, you can define separate Styles based on different conditions of a selected column of data, but I think the style will apply to the entire row.

Islam_Amer
6-Contributor
(To:zyuan1)

Hello Zyuan1,

 

Thanks for your Response

 

I know you can set on Style for Whole Row even the target is the same  but in my case I need Multi Style for multi Targets in the same Rows 

 

Regards,

Islam,

Click on Grid widget, expand the triangle on top left of the widget, open Configure Grid Columns

for each column, you can also assign different State Formatting 

Islam_Amer
6-Contributor
(To:zyuan1)

Yes, this solution for column have one target , what about my case with multi target

Area 1 target 0.2 with results is 0.1 this is mean it will green

but in Area 1 target is 0.4 and the results is 0.5 this mean it will Red

the results in the same column with deference style

Hi @Islam_Amer

 

I am not sure if there is a better way to do this but my team and I have recently had to implement this functionality.

We were able to do this by creating an additional property which is either a string or number property. We then populate the property based on the different target. So in other words, on your area template you would have a graph status property and based on the target per area and the area result, you would populate the graph status property with either green, red or orange for example.

You can then implement this on your mashup by going into your grid widget configuration, selecting Column Renderer & State Formatting of the row of interest ( eg. results), and making the dependent field the graph status property.  Your state definition is then not looking at your result row value but the graph status property for each area.

 

Hope this helps

slangley
23-Emerald II
(To:eengelbrecht)

Hi @Islam_Amer.

 

If one of the previous responses answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.

 

Thank you for using our Community!

 

Regards.

 

--Sharon

Islam_Amer
6-Contributor
(To:slangley)

Hello @slangley

 

No one of previous responses answer solve my problem If I found the Solution I will Share

 

Thanks,

Islam Amer

Top Tags