Aggr Dual as Dimension

[cbaqir]

I am trying to stratify vBuildResourceCount into buckets using:

=Aggr(
If(count(vBuildResourceCount) = 0, Dual(0, 0),
If(count(vBuildResourceCount) = 1, Dual('1', 1),
If(count(vBuildResourceCount) = 2, Dual('2-3', 2),
If(count(vBuildResourceCount)< 5, Dual('4-5', 4),
If(count(vBuildResourceCount) > 5  Dual('5 or more', 5)))))),
DEFECT_ID)

Clearly Jan 2018 has some in  with Build resource count of 1, 2 o3 3 but I only see a bar for 2-3? Help! What's wrong with my Dual statement?

[cbaqir]

stalwar1‌

[swuehl]

Try to add your YearMonth dimension to the aggr() dimensions.

[cbaqir]

How so? This didn't work:

=Aggr(
If(count(vBuildResourceCount) = 0, Dual(0, 0),
If(count(vBuildResourceCount) = 1, Dual('1', 1),
If(count(vBuildResourceCount) = 2, Dual('2-3', 2),
If(count(vBuildResourceCount)< 5, Dual('4-5', 4),
If(count(vBuildResourceCount) > 5,  Dual('5 or more', 5)))))),
DEFECT_ID, FISCAL_MONTH_YEAR)

[swuehl · Accepted solution]

Yes, something like this.

What if you use this as expression in your straight table, to compare with the results of your count expression?