Define a range on Axes

[d_prashanthredd]

Hi Experts,

I have a requirement to build a bar chart or any.

Requirement: Define a range on x-axis i.e. sum(value) for 0-199, 200-399, 400-599, 600-799, 800+

And that should be in an expression rather than in a script.

Note: I have fixed ranges.

Please find the attached qvd and the data is sample.

[kaushiknsolanki · Accepted solution]

Hi,

You should use expression like below.

=Aggr(if(sum(Value) >= 0 and sum(Value) < 200, '0-200',

if(sum(Value) >= 200 and sum(Value) < 400, '200-400',

if(sum(Value) >= 400 and sum(Value) < 600, '400-600',

if(sum(Value) >= 600 and sum(Value) < 800, '600-800', '800+')

)

)

),Field,SubField)

Regards,

Kaushik Solanki

[d_prashanthredd]

Hi Kaushik.. Its working fine.

I missed aggr function.. Thanks a lot.