Advanced/dynamic filtering in OAC

Question

I want to be able to select a Manufacturer in the dashboard filter and the manufacturer column to only show the selected value and for the rest to be blank.

So if I were to select 'FIAT' in the filter the Manufacturer column would present how the FIAT column is preseneting.

I have tried putting a case when into the dashboard filter but I cant get it working, is there a way to do this?

LukePa · Answer

Thanks for the help, unforutnaley they want the Manufacturer column to not be hidden, for example when 'Ace Suppliers' is selected Ace would show and the rest of the manufacturers would have blank columns.

I dont think this is possible though.

Jamie Anderson-Oracle · Answer

Apologies, I don't think my above solution captures the spirit of what you're asking for.

I believe you essentially want to be able to see all of the other Repat Volume values but not the other manufacturer names on-screen when a specific Manufacturer like Fiat (or Ace Supplies in my example) is selected from the Dashboard Filter.

It's not exactly what you had in mind, but I have a workaround.

You will have 3 visualizations:

* Dashboard Filter
* Tile
* Table

Dashboard Filter:

Tile:

Table:

Once those visualizations are created:

Table:
Right-click Manufacturer in the Rows area and select Hide.

Dashboard Filter:

Deselect the checkbox that references the Tile viz under "Apply this Filter to".

(I renamed the Title of my visualizations to convey this):

You can upload the .dva I used by unzipping the attached file and loading it into your environment:

Manufacturer and Repat Volume.zip

Jamie Anderson-Oracle · Answer

@LukePa So what happens if you just remove the FIAT column?

Like this (pretend Ace Supplies says Fiat in the Manufacturer attribute):