Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I show rank for a year as in at textfield:
=aggr(rank(sum({< Frac_counting={'1'}, Period={'2015'}, Region=, Subregion=, Country=, University= >}P),1),University)
Thats works very well for one year.
Then I want to show rank for each year between 2012 and 2015 in a chart.
And then its does not work. And yes I have tried with Period={'2012, '2013', 2014', '2015'} and Period as dimension.
And in addition. Another issue: If I want to show the rank for one particular university then I can't use University={'University of Q'} because when the rank says 1 (and of course - but how to solve this, so I in a chart can show a selected university and a predefined university)
Thanks in advance 🙂
Where you are using this rank function?
What are the dimensions in your chart/table?
or try this
aggr(Rank(sum({< Frac_counting={'1'}, Region=, Subregion=, Country=, University= >}P),1),Period, University)
I have used it in a textfield and it show correct the rank of a selected university.
Then I want to show the rank in a line chart. The dimension are year and the expression for the rank is the same as in the textfield ... (I have tried without Period in the SET-analysis and I have tried adding all years but I still only got one dot and not a line)
Can you try with different Years for same expression and tell us where you are facing issues
or try this
aggr(Rank(sum({< Frac_counting={'1'}, Region=, Subregion=, Country=, University= >}P),1),University)
or
aggr(Rank(sum({< Frac_counting={'1'}, Region=, Subregion=, Country=, University= >}P),1),Period)
Thanks, but sorry that returns no data.
Can you provide few lines of sample data or sample app to work.
Just remove the Period from the set. It should work.
Yes - I try to make a sample and upload - Ill be back 🙂