This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would like to use the Report tool to format rows when the same value appears in another row. In my specific example, I want to highlight those warehouses that have multiple deliveries coming up. Ideally I want the tool highlight in different colors. Thoughts?
In the attached example, you'll see how I identified duplicate records, then generate a random color to be assign to each unique value. This process randomizes the RGB values, so there is a possibility for duplication, so I included an alternative where you could set a list of RGB values to use.
Like @AbhilashR suggested, these color assignments need to be determined ahead of time and placed in a field that will not be displayed by the Table output. Here's an example expression to specify a specific background colors to be used in the Formula options of Row Rules in the Table tool:
Where the RGB values are integers between 0-255. A list of available formatting expressions can be found here in the documentation: