sorting in a bar chart

[#1]

hello all,

first question :

i have a bar chart which has 13 months of data , i need to sort values according to last 12 months of data .

second querstion :

i have defects : p1 to p4 , how do i sort data in below order

p4

p3

p2

p1

Third question :

[#2]

Hi

Can you post sample qvw with some dataset?

thanks

[Peter_Cammaert]

1st answer: use set analysis to reduce the bar chart scope to the last 12 months. BTW what is your first dimension?

2nd answer: sort the defect category dimension Z->A (text)

3rd answer:

[#4]

Hi peter  first dimension is
defect category , first column in table

second answer it is working thanq ,

3rd anwer :

i have a graph . where i am using terc_closing date as dimension

and expression i am evaluating for each terc_defect category

for example for code, i am writing an expression and

for application configuaration i am writing an expression

, i am getting the below graphs

i want months to be for last 12 months , since this monthe is feb

i want

the last graph is the right sort  order, i am giving sort expression as

count({<terc_defect category ={"$(vperviousmonth)")>}terc_defect category