Ranking beastmode with fixed rankings

Options
dacorson
dacorson Member
edited July 7 in Calculations & Variables (Beast Mode)

Has anyone been able to create a beastmode rank that does not recalculate when filtering? I know I can create a static rank in the dataflow, which I have done, but I'd like to figure out a way to mimic a fixed rank in beast mode for those times when I have to do a ranking on the fly and don't have time to run the dataflows again. I tried including a fixed function in the order by clause, but if I filter on our brands, it calculates the rank as 1 since there is only 1 brand in the visual context. I'm assuming it's not possible, but maybe someone figured out a workaround.

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    FIXED would allow you to restrict the filtering however ranking isn't possible with a FIXED function because it doesn't allow an ORDER BY clause. Regular window functions are affected by filtering.

    I'd recommend adding this as an idea to the Idea Exchange

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    FIXED would allow you to restrict the filtering however ranking isn't possible with a FIXED function because it doesn't allow an ORDER BY clause. Regular window functions are affected by filtering.

    I'd recommend adding this as an idea to the Idea Exchange

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • dacorson
    dacorson Member

    Thanks, I submitted a few ideas, including this one.

  • Jones01
    Jones01 Contributor

    @dacorson hi have you got a link to your idea so I can add my vote?

Categories