Focal Point
[SOLVED] Infoassist Visualization - Sort a Bar Graph

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6547082096

May 31, 2018, 11:08 AM
Joe Beydoun
[SOLVED] Infoassist Visualization - Sort a Bar Graph
SOLUTION = The Query Panel was hidden squeezed next to the Data panel. I figured the solution was something this silly. Thanks all.


I hope I'm just missing a feature staring back at me, but I can't find a way in the painter tool to sort by bar graph on the x-axis.
Thanks for the help.


[IMG]Commercial Photography[/IMG]

This message has been edited. Last edited by: Joe Beydoun,


version 8202M
Reporting Server on
Windows Server using DB2 Connect to access data from iseries.
May 31, 2018, 11:44 AM
FP Mod Chuck
Joe

Once you add the measure to the query you can right mouse click on it and choose Sort ascending or descending.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
May 31, 2018, 12:51 PM
Joe Beydoun
I don't have a sort option either from the field select or directly on the chart.
I'm using the Create Visualization Option, not the classic create chart option.

[IMG]Commercial Photography[/IMG]


version 8202M
Reporting Server on
Windows Server using DB2 Connect to access data from iseries.
May 31, 2018, 01:08 PM
BabakNYC
In the Query, right click the measure and you'll see Sort Options. Your Query box isn't opened in the first image you provide and I don't think you can sort once you run the visualization.


WebFOCUS 8206, Unix, Windows
May 31, 2018, 01:53 PM
Joe Beydoun
I'm not sure where to find the Query box. Here is an image of the car file, all I did was drop the Retail cost then the Model into the chart, there is no sort option.

[IMG]Commercial Photography[/IMG]


version 8202M
Reporting Server on
Windows Server using DB2 Connect to access data from iseries.
May 31, 2018, 01:57 PM
Joe Beydoun
Here is what I see when I select Create Chart option. This has the sort. I'm trying to do this but in a visualization.

Commercial Photography


version 8202M
Reporting Server on
Windows Server using DB2 Connect to access data from iseries.
May 31, 2018, 04:00 PM
BabakNYC
You seem to have dragged the Data box's right side over the Query and Filter boxes. Try to grab the right side of that panel and hold the mouse and drag it to the left to see if you can make it visible. I think there's also a rest all options to default that might fix this under Options.


WebFOCUS 8206, Unix, Windows
May 31, 2018, 04:20 PM
Joe Beydoun
Thx BabakNYC, that was the issue.


version 8202M
Reporting Server on
Windows Server using DB2 Connect to access data from iseries.