Replacing grouping header (label) with other caption dependent on underlying row content

Hi, 
 
What is the best way to tackle the following problem:
 
 I have a table with two columns (A and B ) that I am grouping over column 'A'. However I do not want to display the default grouping label and want to display a custom label based on the following logic:
if rows in column B have different content (entries) then display 'Multiple' in group-header row, else display the content of the first row in column B. 
 
here is an example that visually demonstarate desired effect:
 
Suppose I have the following data source table

name | car model

Jill | ford

Jill | chevy

Scott | toyota

When I group over the name I would like to see:
 
Jill | multiple
Scott | toyota
 
 
Can this be done through some design logic or do I have to create event listeners and use onCreate and onRender events?
 
Thanks,

Find more posts tagged with

Comments

micajblock

Create an aggregation with distinct count. Then in the group header have data item with an if expression based on the distinct count.

newbie321

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="145047" data-time="1472057264">
<div>
Create an aggregation with distinct count. Then in the group header have data item with an if expression based on the distinct count.
</div>
</blockquote>
 
Thanks, @mblock!!
 
This is exactly what I was looking for. Your solution works like a charm and is very elegant!!
 
Thanks again!

micajblock

Elegant is my middle name :-)