Challenge: Two-column chart

[cattaneoc]

Hi, I need to create a graph with the next table:

QV can do it?

Thank you!

Carlos

[devarasu07]

Hi,

Something like this?

[el_aprendiz111]

Hi,

[MarcoWedel · Accepted solution]

Hi,

maybe another solution might be:

CrossTable (Type, Value)
LOAD * INLINE [
    póliza, a, b
    1,   7%, 12%
    2,  12%, 23%
    3,   9%,  9%
    4,   4%, 23%
    5,   2%, 24%
    6,   2%, 24%
    7,  18%,  8%
    8,  19%, 17%
    9,   7%,  3%
    10, 23%, 14%
    11,  7%, 13%
];

hope this helps

regards

Marco

[devarasu07]

Hi,

Is your issue resolved? help to close this thread. Thanks

Regards,

Deva

[cattaneoc]

All answers are correct and applicable !! many thanks!!

[cattaneoc]

Hi Marco,

Is it possible to modify the expression so that the zero is a separate bar?

=Aggr(Dual(Num(Floor(Poliza%,Var_Rango%),'0%')&' y '&Num(Floor(Poliza%,Var_Rango%)+Var_Rango%,'0%'),Floor(Poliza%,Var_Rango%)),Poliza%)

Var_Rango% = 5.0%

Example:

-15% y -10%

-10% y -5%

-5% y < 0%

0%

>0% y 5%

5% y 10%

5% y 10%

10% y 15%

thank you very much!