Charting

Charting

Flex Table Sorting by Pct Change

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


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

  • 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

  • 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!**
  • 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