0

Multiple slicers in Mini-Tabs

Hello everyone,
I'm new to Pyramid Analytics and have recently started learning about Mini-Tabs. I was wondering if it's possible to link two slicers to four different Mini-Tabs? I need to use four separate discoveries and navigate between them using these two slicers.

Thank you so much for your support!

5 replies

null
    • Principal Customer Solutions Consultant
    • Eduardo_Azanza
    • 11 days ago
    • Reported - view

    Hi  .

    Yes, you can do it by using 'Interaction Manager'

    or with 'Interaction Picker'

    As you can see in the screenshot below I have connected the two slicers with the report in Tab 1:

    And same thing with the other reports located in the other tabs. 

    I hope it helps.

    Eduardo

    • Aufrida_Pamungkas
    • 8 days ago
    • Reported - view

    Hello Eduardo,
    Thank you very much for your feedback!

    I am sorry I was not very clear at the beginning, actually what I am trying to achieve is if we can use Slicer Actions connecting multiple slicers. To have something like a conditional IF AND in Slicer Actions from more than one Slicer... 

    • Principal Customer Solutions Consultant
    • Eduardo_Azanza
    • 7 days ago
    • Reported - view

    Hi  .

    Apologies for not understanding the question.

    If I understand correctly, what you want is to check the value of more than 1 slicer in an IF condition; this is not possible.
    We can use IF but checking the value of a single slicer.
    In the following screenshot you can see how an IF is used to check the value of the Slicer Country; where we check for two values in Country.

    We could also use Switch, instead of IF, but still with a single Slicer.

    This could be a feature request you could add to the "Product Ideas" section.

    Kind Regards.

    Eduardo

    • Customer Solutions Architect
    • Moshe_Yossef
    • 7 days ago
    • Reported - view

    Hi 

    Like   wrote, there is no straight way to do it.

    You could allow the user to choose one of 4 visuals on their own.

    There is another alternative, although it's a little complicated.

    Step 1: create a custom column concatenating the 2 columns (country and manufacturer in this case)

    step 2: create a present with 3 filters (country, manufacturer, country + manufacturer), and interact the original 2 with the third one:

    You will see that now, the "country + manufacturer" filter will always show the concatenation of the 2 filters.

    Now you can add a mini tab, and create the switch using the country + manufacturer filter:

    In this case, US Or Canada combined with ACME or NUKE will go to mini tab 1, Germany or France combined with Rinuck or Nuke will go to mini tab 2, and anything else will go to mini tab 3.

    The final step is to hide the 3rd filter:

    I have tested it, and I'm attaching a pie file of the example using Pyramid's Sample Demo model - However do notice this may not be performant - as using 2 columns from different table by necessity means they are joined using the fact table just to create a value, however it does work.

    • Aufrida_Pamungkas
    • 7 days ago
    • Reported - view

    Hello Moshe and Eduardo,
    Thank you very much for the tips! I will try it and keep you posted. 

Content aside

  • Status Answered
  • 7 days agoLast active
  • 5Replies
  • 47Views
  • 3 Following