nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Alternating row coloring inside groups

the wizard

Hi all, 
 
I've a dataset, which is being grouped on 2 levels. 
1. Phase no. 
2. Type 
 
All rows inside "type" in my screenshot "software" / "training" / "consultancy" should be nicely alternating colored. But they aren't, because the rownumber isn't unique inside my last grouping. 
 
For this row coloring I'm using a style attached to the datarow with 2 highlights: 
row.__rownum % 2 Equal to 1 --> background color is white 
row.__rownum % 2 Equal to 0 --> background color is blue 
 
Can someone help me in finding a solution, so my row are being colored, where each first row in my group on "Type" is blue. 
 
How it's clear enough. 
 
<a class='bbc_url' href='http://postimage.org/'><img src='http://s18.postimage.org/9a4wmjd7t/alternating_row_color.png' alt='Posted Image' class='bbc_img' /></a>

Find more posts tagged with

Comments

mwilliams

Create a running count aggregation within your most inner group. Then, use this field to set the highlight rule.

the wizard

That's a cool function! It works very well now.
My row inside the second level of grouping now contains the aggregation with function "RUNNINGCOUNT" and aggregates on my second level group.

Of course I had to change the highlight property in my style template to "row.running_count" instead of row.__rownum.

mwilliams

Yep. That's what I meant by use that field in your highlight rule.

Glad it's working. Let us know whenever you have questions!