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 .
we have two dimenions
dottp1p2_enterprisesystem
monthdottp1p2
expression is
sum(days open)/ count(dottp1p2_enterprisesystem)
i use this sort expression
= count({<monthdottp1p2 = {"$(vmonth_current)"}>}dottp1p2_enterprisesystem)
the second image is the right one , for that i also need correspoding novemeber and october values .
i am getting the first image which is a wrong one .
hope it helps
the expression i have is ,
sum(days open)/ count(dottp1p2_enterprisesystem)
and my dimensions are
dottp1p2_enterprisesystem
monthdottp1p2
the sort expression which i am using is
= count({<monthdottp1p2 = {"$(vmonth_current)"}>}dottp1p2_enterprisesystem)
but i am still getting the same values
Hi,
Have you tried by keeping Y-Value at Descending?
Regards
Krishna
any help is much appreciated
Hi,
Please try this expression at your calculated dimension and let me know.Please edit this expression as for your second dimension also.Keep your expressions remains same and please, let me know that" (sum(days open)/ count(dottp1p2_enterprisesystem)) " is the only expression you are using? If yes, please replace your second dimension field in the below expression and try it.
=Aggr(Only({<dottp1p2_enterprisesystem={"(sum(days open)/ count(dottp1p2_enterprisesystem))"}>} dottp1p2_enterprisesystem), dottp1p2_enterprisesystem)
Regards
Krishna
i am getting only one value 63 , i dont know what it is about . it is a wriong value i feel . i have two calculated dimenions you mentioned and i have expression measure as sum(days open)/ count(dottp1p2_enterprisesystem).
i am attaching you image too.
any idea krishna , why it is giving this value . i am not not good with aggegrate function . can you tell me what you were trying to acheive with those calculated dimension ?