Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to use a reference line for the maximum influence rank. I have names on the y axis and rank on the x axis. Its a vertical bar chart. I dont want to just put a number in the expression where reference line is calculated as it can move. Also I dont want to have the reference line moves if I click on a name but I want it to be static at the Max rank all the time so as to compare. Any help is much appreciated? I have used this expression but with no luck
Max(aggr(Name,CommentPostCount))
If your expression is sum(Something) then the expression for the reference line could be max({1}aggr(sum({1}Something), Name)). If you use a different expression for your y-axis values then replace it with that. Just add the {1} to ignore the selections.
Oops sorry the expression I used is Max(aggr(Name,Comment/PostCount)). Forgot to add the division line. But still doesnt works.
If your expression is sum(Something) then the expression for the reference line could be max({1}aggr(sum({1}Something), Name)). If you use a different expression for your y-axis values then replace it with that. Just add the {1} to ignore the selections.
Your earlier post made it work Gysbert. Max({1}Comment/PostCount)
Could you explain what exactly its doing? Is it just taking the max and keeping the first entry always?
Thanks a lot BTW. Much appreciated.