Forum Discussion

Joe_100's avatar
Joe_100
Icon for Helper I rankHelper I
8 years ago

Table visual, dynamically select multiple value

Hi all,   Maybe it's possible, maybe not. I have the following question: I have a table that looks a bit like this(overly simplified).   Company           Name                 ID Test1         ...
Joe_100's avatar
Joe_100
Icon for Helper I rankHelper I
8 years ago

Hi bizbi,

 

thanks for your reply, although i'm not sure if we are on the same page ;)

 

What i try to achieve is maybe a bit more complicated, and i don't see how merging column will solve this.

 

Let me try to explain what i want to achieve;

 

I have one table and basically some records are related to each other.

It doen's really mather what kind of visual i take (slicer,table,matrix) but at the moment i select a record in the visual it needs to search in that same table if there is a related record and also mark this record in the visual.

 

I need a sort of lookup that starts on the moment of selecting something in the visual....

 

 

Hope this helps a bit.

bizbi's avatar
bizbi
Icon for Advocate I rankAdvocate I
8 years ago

Is it not possible to put a slicer using ID column?

 

My best guess is that IDs are not user friendly so probably you need names.

 

In such a scenario, a possible workaround is to put the ID slicer next to your existing table. Selecting a 'Select All' option on the ID slicer can do the trick.

  • Joe_100's avatar
    Joe_100
    Icon for Helper I rankHelper I
    8 years ago

    Thanks for the suggestion, unfortunetaly it's not working.

     

    If i select a record on the table it won't filter the slicer.

     

    I'm a bit afraid that what i want is not possible... 

    • bizbi's avatar
      bizbi
      Icon for Advocate I rankAdvocate I
      8 years ago

      Got the workaround to work.

       

      Between the table and the slicer discussed earlier, just use Attribute Slicer (import from Marketplace) and use the name column in it. It gives the flexibility to search by typing the name. Entering 'John' into it would automatically both the table and the slicer to fields related with John. Now select '100' in the slicer and it's done.

       

      Though a bit lengthy, but hope it works for your case.