topic Re: How to get classes of this range in Reporting Service & Alerting

How to get classes of this range

lincoln — Tue, 21 Jun 2022 02:34:31 GMT

$0	$ 5,000
$5,001	$ 8,000
$8,001	$ 12,000
$12,001	$ 15,500
$15,500	$ Above

Re: How to get classes of this range

sidhiq91 — Tue, 21 Jun 2022 05:37:38 GMT

Hello,

You can use the below expression in the script editor. Please let me know if that had helped.

Pick( Match(-1,Sales>=0 and Sales<=5000,
Sales>5000 and Sales<=8000,
Sales>8000 and Sales<=12000,
Sales>12000 and Sales<=15500,
Sales>15500),
'0-5000','5000-8000','8000-12000','12000-15500','Above') as Bucket

Re: How to get classes of this range

lincoln — Tue, 21 Jun 2022 06:21:34 GMT

can you explain why -1?

Re: How to get classes of this range

MayilVahanan — Tue, 21 Jun 2022 06:39:19 GMT

Try like below, dual function helps for sorting purposes

=if(Sales<=5000, Dual('below 5000', 1),
if(Sales<=8000, Dual('5001-8000',2),
If(Sales<=12000, Dual('8001-12000',3),
If(Sales<=15500, Dual('12001-15500',4), Dual('Above 15500', 5)))))

Re: How to get classes of this range

sidhiq91 — Wed, 22 Jun 2022 02:25:39 GMT

@lincoln Please mark it as a solved, if it has resolved your issue. Thanks.