topic Re: Sorting in Data Explorer in SAS Visual Analytics

Sorting in Data Explorer

sarahj — Thu, 06 Jul 2017 03:29:10 GMT

I am trying to do some exploration using the Data Explorer in VA. I know with report designer, you can use custom sort to have a customized sorting/fix sorting of a variable. Is it really not possible to do it while in Data explorer? Been trying to figure it out but I can't seem to find it.

Bar Chart

No Sort option when variable is right-clicked on.

By the way, version of VA I'm using is 7.3.

Sarah

Re: Sorting in Data Explorer

ScottJP — Thu, 06 Jul 2017 09:28:05 GMT

Right click on the category in the chart, and you have a sort option in there.

I'm not sure if custom sorts are available (in the same way as they are in the Designer).

Re: Sorting in Data Explorer

sarahj — Thu, 06 Jul 2017 09:41:28 GMT

I don't have the same options as you have. Here is what's showing in mine.

Re: Sorting in Data Explorer

ScottJP — Thu, 06 Jul 2017 10:25:15 GMT

I get the same menu as you if I right click on the chart background - you have to right click on the category box..On CLUSTERIDNEW

Re: Sorting in Data Explorer

sarahj — Thu, 06 Jul 2017 10:31:35 GMT

There might be something wrong with my VA as the right click option is the same as when I click on the background and when I click on the box as you have illlustrated.

Re: Sorting in Data Explorer

ScottJP — Thu, 06 Jul 2017 10:45:52 GMT

Maybe it's different in 7.3 then - I'm in 7.4 and this different menu is displayed.

Maybe someone else with 7.3 knows another way, but in 7.4, you would simply right click your category. (Either way, you should think about upgrading to 7.4 already, as there are lots of bug fixes in this update).

Re: Sorting in Data Explorer

sarahj — Thu, 06 Jul 2017 10:54:07 GMT

Thanks Scott! I'll look into that. Would need to consult our team if an upgrade to 7.4 if feasible. If not, I hope someone with 7.3 could give me some enlightenment on this matter.

Re: Sorting in Data Explorer

ScottJP — Thu, 06 Jul 2017 12:13:52 GMT

Cool - We've recently upgraded; our SAS dealer did it for us though. Didn't have any issues, and would recommend it.

Re: Sorting in Data Explorer

Sam_SAS — Thu, 06 Jul 2017 13:10:23 GMT

Hello,

I did a quick test in 7.4 and 7.3 and there does not appear to be any difference in sorting between the two. (There are other good reasons to upgrade, however!)

In my test, the context menu with the Sort option does not appear if a lattice role is assigned, or if you right-click a data item that is assigned to the Group role.

But Sarah's screenshot doesn't seem to show either of those scenarios.

You might want to check with technical support to figure out just what is going on here. Are you using a browser other than IE, Chrome, or Firefox?

Thanks,

Sam

Re: Sorting in Data Explorer

Sam_SAS — Thu, 06 Jul 2017 13:30:35 GMT

Sarah, can you check whether sorting is available under the same conditions in the report designer? There are some sorting differences between the explorer and designer.

Thanks,

Sam

Re: Sorting in Data Explorer

sarahj — Fri, 07 Jul 2017 04:25:22 GMT

Thanks for the input Sam. The variable wasn't used as lattice or group by so it isn't causing that. I did ask some colleagues of mine to do some testing. And it worked out fine for them. But apparently there were using Chrome. I was using IE. it seems the browser that was used caused it. Maybe there is a set up/options/properties if IE that is causing the malfunction. I just can't figure out what. So I'll use Chrome for now.

Thanks!

Sarah

Re: Sorting in Data Explorer

Sam_SAS — Fri, 07 Jul 2017 12:35:02 GMT

Hi Sarah,

Thanks for following up, and I'm glad it is working for you in Chrome. Generally Chrome is the browser that works best for VA.

Sam