Charting

Charting

Is there a way in Domo to show/hide columns in a table type of card ?

so I have a table card which has 10 total columns (i.e. column 1-10). I want to give an option on my end application (where I would embed my dashboard) to user to see only selected columns dynamically in this table.

So a user can select that I don't want to see column 5 and column 8, so this table should hide those 2 columns for that user.

How can I achieve this ?

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

Comments

  • there is not currently a way in a table card to allow the end user to conditionally hide columns. You could use PDP to hide values if you need to hide sensitive information.

    **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.
  • Contributor

    If you pivot your data into the structure below, you might be able to achieve that..

    Date, Column Name, Value

    render using a pivot table and set the Column Name as filter


  • Member
    edited January 2024

    @MarkSnodgrass Is this still a limitation? It would be great if there was a beast mode function to hide/show columns. E.g. Case when metricname = 'Budget' then showcolumns (1,2,3 ) when metricname = 'Actual' then showcolumns(4,5,6) else showcolumns(all) end. Something along those lines would be amazing…

  • Search for the 'Dynamic Columns Brick' in the appstore. It's relatively easy to set-up and does what you're describing in your original post.

    Otherwise, I would use @michiko's suggestion. Or, if you want a filter that's 'Budget' vs. 'Actual', then after pivoting your data, you could add a column with a case statement like you described coding the columns to Budget or Actual and use that as your filter.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

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