Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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?
Create Month([terc_ClosingDate] as a field in your script. This cannot be used directly in set analysis.
i have that field in the script , that is why i am able to sort values according to month wise .
First Dim - terc_DefectCategory
Second Dim - Month([terc_ClosingDate])
Sorting Tab:
Sum({<Month([terc_ClosingDate])={$(=minstring(Month([terc_ClosingDate])))}>}terc_DefectCategory)
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.
thanks to utkarsh and vignesh
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 .
You are not getting the right sorting order?