Skip to content

    • Charting

    Charting

    Flex Table Sorting by Pct Change

    Member
    in Charting

    Is there a way to sort Flex tables by the % or value change? I want to show the top 20 rows that has the highest % or value change. I only see the option to sort by total which doesn't work for my use case. Thanks

    image.png


    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Answers

    • Coach

      If you can re-create that percent change in a beast mode then you can drag that beast mode into the sorting properties.

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Member
      edited August 2021

      How do I create the % change in beast mode? This is a calculated column from the Flex table

    • Coach

      Typically it’s just

      (‘New’-‘old’)/(‘new’) but it depends on how you have your percent change metric defined in the card settings. Which method are you using?

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

      The percent change/value change is automatically calculated by the Flex table.

      I'm looking at value and % change from the pentultimate value to the last value.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories