Freeze Numeric Value in Pivot Table Card

Options
Sam_Y
Sam_Y Member
in Cards, Dashboards, Stories

Is there a way to have a value be frozen and operate independently of the column? Example attached…the highlighted column would stay static.

Capture.PNG

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    You can use the settings on a table card under General > Number of Locked Columns to specify the number of columns on the left you want to freeze.

    Screenshot 2024-03-05 at 3.52.08 PM.png

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

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    You can use the settings on a table card under General > Number of Locked Columns to specify the number of columns on the left you want to freeze.

    Screenshot 2024-03-05 at 3.52.08 PM.png

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

    Thanks @GrantSmith Is that option just for Mega Tables? I don't see it on Pivot Tables

  • MarkSnodgrass
    MarkSnodgrass Coach
    Options

    I believe you need to move your Leads field out of values and into rows and then aggregate it the same way you had in in values.

    **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.
  • Sam_Y
    Sam_Y Member
    Options

    @MarkSnodgrass I keep getting the "An issue has occurred during processing. We are unable to complete the request at this time." when I do that.

Categories