Jump to content

Is there a way to tell if columns are used in visuals

Manoj Chaurasia

Recommended Posts

  • 1 year later...

I don't think if there is any direct way to find out columns used. You need to check your visualizations/tabs and with business what all columns they need and some columns might not be used directly but they might be used in some calculations. When the business confirms about the columns then you can remove them.

Normally what happens, we just dump all the data and columns from datatables/Info Links into Spotfire client without checking what all will be used which impacts the performance in long run.

Link to comment
Share on other sites

  • 3 years later...
  • 11 months later...

I just tried to delete a calculated column that was being used in my report, and Spotfire gave me a pop-up saying "Other columns in the analysis depend on a column you are about to delete" and then gave me the option to Delete, Hide, or Cancel.

However, it wasn't fool-proof and I ended up deleting a column or two that were used in the analysis (I have a backup version saved and undo also worked fine - just ran this as a test). It would be very beneficial to have another method of checking or having an indicator that shows whether it is used or not used.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...