Chart help

[#1]

Hello,

I have got the following question. I want to create a chart with the number of unique SERIALS on the y-axis and how many times they are repaired on the x-axis.

The source data looks like this:

REPAIR	SERIAL
R0001	12345
R0002	12366
R0003	12367
R0004	12345
R0005	12368
R0006	12345
R0007	12367
R0008	12369
R0009	12370

The chart should look something like this:

So it displays the number of unique serials and how many times they are repaired within the selection.

Hope you guys can help!

Regards, Sander

[Oleg_Troyansky · Accepted solution]

Sander,

sure, this is what Advanced Aggregation is for:

1. Create a calculated dimension:

=aggr(count(Repair), Serial)

2. Create an expression:

count(distinct Serial)

3. Pretty up and enjoy!

[#3]

Advanced aggregation.... Off course...

Thanks, Oleg! You're the man!