Forum Discussion

zamboni1199's avatar
zamboni1199
Icon for Helper II rankHelper II
5 years ago
Solved

Linking a table to a chart

Hi - I have a report of data I'm presenting.  Underneath it, I've a added a chart to reflect that same data.  When I add a filter to the report on top, the chart below does not get automatically upda...
Need Help
  • zamboni1199's avatar
    zamboni1199
    5 years ago

    Ok, the solution was pretty obvious but I just missed it.  When I set up my filter, I mistakenly set it for "Filter on this Visual", which filtered the table data only.  By changing the filter to "Filter on this Page" it filtered both the table and the visual underneath it on the same page. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello - 

 

Did you set up a relationship between the tables? 

zamboni1199's avatar
zamboni1199
Icon for Helper II rankHelper II
5 years ago

Thank you.  It's one table of data with a visual underneath it.  Is there a way to set up a relationship between the tabular data above and the visual below it?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    So click on the filter and go to Format > Edit Interactions. On the visuals, select the Filter icon in the top right.  This will tell the visuals to filter each other and interact with each other when you filter. 

     

     

    • zamboni1199's avatar
      zamboni1199
      Icon for Helper II rankHelper II
      5 years ago

      Hi thanks for your time slschmitt.  I figured it out.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi zamboni1199 ,

        It's glad to hear that you find the solution to your problem. Could you please share your solution and mark your post as Answered if you are willing to? And it will help the others find the solution easily if they face the same problem with yours. Thank you.

        Best Regards

    • zamboni1199's avatar
      zamboni1199
      Icon for Helper II rankHelper II
      5 years ago

      Thank you.  I know I'm not doing something right.  I have the table data filtered by year (>= 2021).  I then clicked on Edit Interactions, clicked on my visual and clicked on the filter icon.  Nothing happened.  I still have 2019, 2020, and 2021 data in the visual.  Perhaps you can right click on the image below and "Open in New Tab" to view it.  Thanks.