Display X & Y-axis values in customized order

[Anonymous]

Hi All,

I've different charts in my .qvw file & I've created bar graph based on severity,

X-Axis is: Severity & Y-Axis is: 1 week,2 weeks and others ,the graph is working fine but the problem is X-Axis names are displayed in ASC order.

I've attached my sample graph for your reference.

I want DISPLAY names like LOW, MEDIUM,HIGH & CRITICAL? and How can i customize to display the names OR Values?

[#2]

You can go to sort tab in chart and use expression for sort order.

Write an expression like if(severity='LOW',1,if(severity='MEDIUM',2)) like wise.

or you can create and inline table with two fields severity and num, give the order over there.

HTH

--

amay

[Colin-Albert]

Define your dimension for low, medium, high etc using the DUAL() function.

See this post for more details.  Dual function