07-05-2017 11:29 PM
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.
No Sort option when variable is right-clicked on.
By the way, version of VA I'm using is 7.3.
07-06-2017 05:27 AM - edited 07-06-2017 05:28 AM
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).
07-06-2017 06:31 AM
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.
07-06-2017 06:45 AM
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).
07-06-2017 06:54 AM
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.
07-06-2017 09:10 AM
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?
07-06-2017 09:30 AM
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.
07-07-2017 12:25 AM
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.