DaleW

I've solved the problem by setting up the data so that there are always values for each of the three status types, including if the value is 0. This works well. Thanks for your thoughts and time.

Thanks for your response. The answer is yes. I created (copied an existing style and modified it) and changed the colors. Here's the problem. This capability summarizes the status of investments. They are either red, yellow or green. The chart provides a summary of the number of investments in each of those statuses. I've set the style for three colors in this order: Red Yellow and Green. I've set-up the chart to sort in that order as well. When there are investments that have statuses in all three states, the style works great. But, for example, if there are no investments in a red status, there is no data to present. That means that Yellow is the first data group on the stack. Since red is the first color in the style, and the yellow summary is the first group in the stack, what should be displayed as yellow gets displayed as red, which is inaccurate. That is the problem I'm trying to solve. The same problem would happen if there were no investments in a yellow status. The green investment summary would be displayed as yellow because it would be the second group in the stack, since yellow is the second color in the style. Thanks, again, for your response. I'd be interested in any thoughts you have on how to solve the problem.

I have a chart where I have selected a stacked column. The data for the stacked column is one of three types. The stacked column counts each type and returns a value. I'd like to have a specific color appear for a specific type. That wouldn't be a problem if all three types are present all the time. They are not. Sometimes, a type may not be present. I have set and applied a style to this datapage where three custom colors are assigned to appear. It works great when all three datatypes are present. No so much when they don't. The problem is that when not all types are presents, the colors display aligns to different types, which will be confusing to users. I'd like to be able to do this: Datatype 1 = color 1 Datatype2 = color 2 Datatype3 = color 3 I'd like the same color to appear with each datatype regardless of whether other datatypes are present. I don't code, and I'm wondering if anyone has a solution to this problem. Assistance would be greatly appreciated. Thanks.

Hit send prematurely. Please disregard the sentence "The background color of the row should already be in the table". Doesn't make any sense, does it? Sorry.

Wow! Many thanks. I'm pretty good with Caspio functionality but get a bit lost when code starts getting involved. Please share how to deploy the code? I assume it is deployed in a HTML Block on the results page. Also, the field that determines the color of the row is already in the table by row. There isn't a need to select anything. The background color of the row should be already in the table. Would that change how this is built? This looks like quite a bit of thinking. I really appreciate the effort and look forward to your guidance. Thanks.

I'd like to dynamically change the color background of a results page. Caspio provides Javascript to do this, but it operates on a single condition. Here's the code they provide: <script> var isi = document.getElementById("visi[@field:UniqueFieldName]"); if('[@Yes/No FieldName]' == 'Yes'){ isi.parentNode.parentNode.style.backgroundColor = '#YesColor'; } else{ isi.parentNode.parentNode.style.backgroundColor = '#NoColor'; } </script> This works great on a single yes/no condition, but I need to have four different colors displayed depending on the condition of a single field: If fielda=1, display color 1 If fielda=2, display color 2 If fielda=3, display color 3 If field a=4, display color 4. I love Caspio because as a non-programmer, I can do many, many things. But I don't code and could use some help modifying the java script to produce the outcome I'm seeking. I'd be very grateful if someone could provide assistance. The datapage is a tabular report. Many thanks. Dale