Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Country | t_normalized | Sum_Incidents |
---|---|---|
A | -2 (formerly 1) | 16 |
A | -1 (formerly 2) | 19 |
A | 0 (formerly 3) | 21 |
B | -3 (formerly 2) | 3 |
B | -2 (formerly 3) | 4 |
B | -1 (formerly 4) | 3 |
B | 0 (formerly 5) | 26 |
Country | Region | Date | Incicents |
---|---|---|---|
A | R1 | 1 | 5 |
A | R2 | 1 | 6 |
A | R3 | 1 | 5 |
A | R2 | 2 | 9 |
A | R3 | 2 | 10 |
A | R2 | 3 | 12 |
A | R3 | 3 | 9 |
A | R4 | 4 | 8 |
A | R1 | 4 | 11 |
B | A1 | 2 | 1 |
B | A2 | 2 | 1 |
B | A3 | 2 | 1 |
B | A2 | 3 | 2 |
B | A3 | 3 | 2 |
B | A3 | 4 | 2 |
B | A2 | 4 | 1 |
B | A1 | 5 | 9 |
B | A2 | 5 | 8 |
B | A3 | 5 | 9 |
Maybe like attached?
I don't think I can do this in one chart. I've put two on top of each other in the attached example. If you have more countries that is not going to be practical. It could be made to work for comparing countries pair-wise.
Thanks Gysbert
I think this should be possible though...meanwhile I got a step closer:
sum({$<Datex={'$(=min(aggr(if(aggr(sum(Incidents), Country, Datex)>20,Datex,10000),Country, Datex)))'}>} Incidents)
Provides some, put not all results, output looks like this:
Country | sum({$<Datex={'3'}>} Incidents) |
A | 21 |
B | 4 |
What I don't get is why the output or the set modifier is evaluated only as '3', and not as '5' for country B....
Ideas anyone?
Maybe like attached?
Exactly like the attached. Thanks a lot - will try to understand the formula..:-)