Sorting in Vertical Bar Chart

Chandra M. G.

Hello,

I have a requirement where i need to present data in Vertical Bar chart format using direct SQL query on database with connection pool.

As a query output, data is in well sorted format as a tabular form but when i go to present them in vertical bar graph that sorting completely wipe out.

Like my tabular data is populated in below format -

  

Program	Rank	Value
Research Insight	1	0
Galaxy Desktop	2	1
Metis	2	1
AWS	3	2
End Investor	3	2
GFDR	3	2
Galaxy Mobile	3	2
Mercury	3	2

It sorts data as per program value in bar chart, please help me to sort this out.

Thanks

Chandra G.

Joel

It would be useful if you could provide a screenshot showing what your issue is.

ArijitC

In vertical bar chart, Horizontal Axis is always sorted by what you have in horizontal axis. No matter if it is a direct connection or not. I have not found anything in the property file to change this inherent property. I have overcome this issue different way. I have duplicated the measure column and converted it to character with some left padding. In this example my user count is always below 999, so I have 3 left padding.

Now put that lapd column before user_name.

You get order by measure column like this….

Now hide the duplicate lpad column in ..

That’s it.

So you get report from

  To

Chandra M. G.

I have tried by using RANK option given value as A,B,C to RANK value so that it can sort. Now its sorted but all the formatting got distorted like below.

If you see Rank value (A, B, C) is on x-axis but their bar graph is moved to right/left side, also legend value is sorted alphabatically.

Can you help us.

Thanks

Chandra G.

ArijitC

Can you edit the graph and show your Layout please.

Thanks

Arijit

Chandra M. G.

ArijitC

Drag RANK to "vary color by(horizontal Axis)" section before Product_name. Then hide RANK from column properties in criteria section. If you need to group by "RANK" then duplicate that column and use it in both group by section and color by section.  You are using it in color by section with hide option just to force it to sort x axis.

Thank You

Arijit

Chandra M. G.

I think that can be possible if we are creating using criteria analysis but i am creating using logical SQL on connection pool. So unable to achieve the same.

ArijitC

Do you mean hiding column or dragging column in to horizontal axis? both is very well possible for direct database connection.