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.
Sort by numeric value descending
i am not getting the right answer when i sort by numeric value . let me more clear .
i have two dimenions . product and month and expression is count of product . i am also following up with an example . i need my chart to display exactly like the one in below graph which i created in excel
Oct | Nov | Dec | ||
A | 55 | 10 | 60 | |
C | 12 | 22 | 45 | |
B | 15 | 20 | 30 | |
D | 80 | 10 | 20 | |
E | 20 | 100 | 10 |
PFA
Hope this helps
as far as i see , the qvw file which you sent . the sort is done on state = ascending order . but i dont see my data is sorting still on basis of highest last uploaded month(December highest number ).
please check the picture which i presented here
Make a variable to store the value of the latest month. lets say december. Then use this expression in sort by expression set to descending value for Product.
=Count({<Month field name= {"$(Variable name"}>}Product)
Hi adithya,
Check this
hi vignesh , could you please just give me the sorting expression or the logic . i dont have a licenced version
i utkarsh i created a variable using vmonth= Month(AddMonths(Today(),-1)) and i am getting month has dec , but when i am giving in the expression i am not getting the right value
if i am right , i used that sorted expression in expression tab , if the expression i am using is right
=Count({<Month field name= {"$(vmonth"}>}Product) , i should get only december month data right ?
please correct me if i am wrong
Count({<Month field name= {"$(vmonth)"}>}Product)
You missed a bracket there (after vmonth)