Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi..
I have an expression like "Margin" with records 1 to 1lakh (1,2,3...........10000000 ). I want to show a bar chart with ranges >10000,>20,000 and >50,000. I want to show count of Margin >10000 and >20000 and >50000. Could anyone please suggest.
Hi,
You can use function CLASS()
Regards,
Andrey
Here an example.
I used flag to categorize data and after i have created new table category. Fortunately, you will have to change your key in you category table.
Hope that it will help you.
Hi.It is not working for count of margin..pls suggest any other..
Hi,
As variant example in attached file.
Value - classifiable field.
Dimension:
=If(Value<20000, Class(Value, 10000, 'x'),
If(Value>=20000 And Value<50000, Class(Value, 30000,'x', 20000),
If(Value>=50000, Class(Value, 450000,'x', 50000)
)))
Expression:
Count (Value)
Regards,
Andrey