I am designig a SaaS product and it has a table that is mixing different types of data.
It's a sort of register that lists all customers' assets. It provides a ton of value to the users, giving them a bird's eye view of everything that their org is operating.
The table has a lot of very common columns – name of the item, type of item, when was it discovered – total of 5 columns that are quite simple and common.
The thing is, the table is actually mixing data from 20 different sources. Each source has its own type of data – for example, some assets are physical, and some are digital. Users want to narrow down these results to see each type on their own. When they do this, in addition to the 5 original columns, there are 2-4 new columns that are unique to each item type that we can display.
What I am struggling with is how to properly design the UI for this workflow. The product predates me, and when I joined the pattern was already established, through a UI component that looks like a second navigation panel.
Essentially there was one standard navigation panel on the left, with a list of dozen or so pages, and inside the work area, they were showing yet another smaller navigation that was listing all asset types. The first choice was All Types, and then it listed all 20 types of assets below. It had its own scrolling, filters for each type, etc.
Right after I joined, this pattern was being changed, and this time it was presented as a large dropdown at the top of the table. I had some influence on how it was designed, but that decision was very rushed.
Now I have some time to properly design this page, but I am not sure what is the right way to do this. Here are my options:
Option 1) Keep it the way it is. Big dropdown on top, user changes type of items they view, it adds a few columns to the table and introduces unique filters for this item type. When user changes the selection the filters are reset, columns change. It kinda works but honestly feels really weird and is not a pattern I have seen before.
Option 2) Bring back the second navigation. Logic for resetting filtering stays same as above, but it sets better expectation since it's almost like you do navigate to a different page.
I do not know of any other option that might work here, and this is where I would really appreciate your advice!