Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Sorting in Data Explorer

Reply
Occasional Contributor
Posts: 8

Sorting in Data Explorer

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

Bar Chart.PNG

 

No Sort option when variable is right-clicked on.

No Sort.JPG

 

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

 

Sarah

Contributor
Posts: 22

Re: Sorting in Data Explorer

[ Edited ]

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).

 

 Capture.PNG

 

 

Occasional Contributor
Posts: 8

Re: Sorting in Data Explorer

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

 

No Sort (2).JPG

Contributor
Posts: 22

Re: Sorting in Data Explorer

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

 

Capture2.PNG

 

Capture3.PNG

Occasional Contributor
Posts: 8

Re: Sorting in Data Explorer

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.

Contributor
Posts: 22

Re: Sorting in Data Explorer

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).

Occasional Contributor
Posts: 8

Re: Sorting in Data Explorer

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.

Contributor
Posts: 22

Re: Sorting in Data Explorer

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

SAS Super FREQ
Posts: 289

Re: Sorting in Data Explorer

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

SAS Super FREQ
Posts: 289

Re: Sorting in Data Explorer

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

Occasional Contributor
Posts: 8

Re: Sorting in Data Explorer

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

SAS Super FREQ
Posts: 289

Re: Sorting in Data Explorer

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
Ask a Question
Discussion stats
  • 11 replies
  • 310 views
  • 0 likes
  • 3 in conversation