Facing issue with filling same rgb(colour) to last week

[mayankraoka]

Hi All,

I am having an requirement ,In which I have 3 dimension customer name,seg and week.Week is pivoted .I have attached the sample application for example.

In the attached example,Refer row 5 in this example I want the same RGB of 20151211 value 0.1 and after that all blank value should be same color as of value 0.1% and earlier blank value of week-20151204 should be grey.In short  whenever there is value after that if there is blank value that should have same rgb as that of earlier value column.If first value is blank that it should be grey color.

Can anyone help me or let me know in case of any other info required?

Regards,

Mayank !

[mayankraoka]

Hi John,

Value loop is not taking the RGB value here right?

Regards,

Mayank

[johnw]

I'm not sure what you're asking. The valueloop portion of the expression is just a way of going to the left an arbitrary number of cells while looking for a value to use. We then use that value to decide what RGB value to use for the cell.

[mayankraoka]

Thank you so much John.Really appreciate your efforts..

Thanks a lot for detail explanation.

Regards,

Mayank

[mayankraoka]

Hi John,

After long time again back to the issue.I have successfully implemented the above approach.The minor change in requirement is breaking the code.

Now instead of displaying the numbers we want to display range on the chart like 0-10,10-20,....90-100.

When I am using range in expression colors are not coming for remaining blank columns.

Can you please help on this?

Regards,

Mayank