topic Re: How to Top N by Sum in Bar Chart in SAS Visual Analytics

How to Top N by Sum in Bar Chart

Derick — Fri, 19 Jul 2019 07:00:50 GMT

I have a barchart where Category set to Customer, while Measure set to Amount. I need to show Top 10 record in barchart. How I can do that? Please help.

Re: How to Top N by Sum in Bar Chart

koyelghosh — Fri, 19 Jul 2019 07:22:57 GMT

Please post a little more detail.

Re: How to Top N by Sum in Bar Chart

PeterClemmensen — Fri, 19 Jul 2019 07:39:27 GMT

Modify the code a bit in An easy way to make a "Top 10" table and bar chart in SAS

Re: How to Top N by Sum in Bar Chart

Derick — Fri, 19 Jul 2019 07:39:59 GMT

I have attached my current bar chart. Now it show all customer record in the bar chart, I need show only Top 10 amount in barchart

instead of all customer record.

Re: How to Top N by Sum in Bar Chart

Derick — Fri, 19 Jul 2019 07:41:11 GMT

I just use SAS VA, didn't use any coding. How I use the coding in SAS VA?

Re: How to Top N by Sum in Bar Chart

PetriRoine — Fri, 19 Jul 2019 12:23:37 GMT

Hello @Derick

Have your tried to use Rank? You can use the Ranks to subset the data in your visualizations. A rank selects either the top (greatest) or the bottom (least) aggregated value for a category.

Best regards,

Petri

Re: How to Top N by Sum in Bar Chart

PeterClemmensen — Fri, 19 Jul 2019 12:32:27 GMT

Ah ok, Didn't see that. I have no idea about VA 🙂