Sorting in a bar chart

[#1]

Hi All ,

i have a trend graph on a bar chart , were i am uploading 3 months of data . i would like to sort data on the basis of last uploaded month data.

for example : i am uploading data for october , november and decemeber . now i need to sort data on the basis of december data and i need to show respective november and october months data .

hope this information helps.

[Anonymous]

Dims:

1.product

2.month

Expr:

count

In Sorting tab:

1.For product dim sort by expression (Descending) and use this expression

"sum({<Month={$(=minstring(Month))}>}Count)"

2.For month dim uncheck all

Thanks,

Vignesh

[#3]

my dimensions or

Month([terc_ClosingDate])

terc_DefectCategory

the expression i am using is

Count({<[Month([terc_ClosingDate]])]= {'$(vmonth_current)"}>}[terc_DefectCategory]

still i dont find any change

[#4]

hi vignesh,

i am touch confused with minstring function

my dimensions or

Month([terc_ClosingDate])

terc_DefectCategory

so according to your script

sum({<[Month([terc_ClosingDate]])]={$(=minstring(Month([terc_ClosingDate))}>}Coun[tterc_DefectCategory])"

is this the right script?

[Anonymous]

Create Month([terc_ClosingDate] as a field in your script. This cannot be used directly in set analysis.

[#6]

i have that field in the script , that is why i am able to sort values according to month wise .

[Anonymous]

First Dim - terc_DefectCategory

Second Dim - Month([terc_ClosingDate])

Sorting Tab:

Sum({<Month([terc_ClosingDate])={$(=minstring(Month([terc_ClosingDate])))}>}terc_DefectCategory)

[Anonymous]

Make Month([terc_ClosingDate]) as Month in Script.

Use Count({<Month= {"$(vmonth"}>}Product) in sort expression

Don't use date function in set analysis directly. They don't work in set analysis.

[#9]

thanks to  utkarsh and vignesh

[#10]

hello  additional help , i have a situation here . we have now two dimenions

dottp1p2_enterprisesystem

monthdottp1p2

expression is

sum(days open)/ count(dottp1p2_enterprisesystem)

now when i use the sort expression

= count({<monthdottp1p2 = {"$(vmonth_current)"}>}dottp1p2_enterprisesystem)

i am not getting the right values

previously the expression was count

now it is average .

[Anonymous]

You are not getting the right sorting order?