Forum Discussion

gree1502's avatar
gree1502
Icon for Helper II rankHelper II
9 years ago
Solved

Filtering table

Hi,   I have a column called "ID" with unique values. A bar chart using this column shows count of ID.   Also I have a table representing all the values of the ID. I am applying a visual filter ...
Need Help
  • parry2k's avatar
    parry2k
    9 years ago

    Seems like because you don't have any field on Axis, you cannot cross filter. Do one thing,

     

    drop A field on Axis on Count of A Graph

    drop B field on Axis  on Count of B Graph

    drop C field on Axis on Count of C Graph

     

    and then try....

gree1502's avatar
gree1502
Icon for Helper II rankHelper II
9 years ago

Thanks for the response.

 

I cannot go with second option because, I have 5 bar graphs and if I click on each bar graph, the table should be updated.

 

I did the 1st option, but it isn't working. 

 

What could be the possible problems?

 

Thanks

parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 years ago

When you say it is not working, wat does that mean?

 

Here is what I understood, you have 5 bar graphs and a table from same dataset, logically when you select any of the bar from a graph, it will cross filter other graphs and table assuming interaction is enabled between visuals. Is this working as expected? 

  • gree1502's avatar
    gree1502
    Icon for Helper II rankHelper II
    9 years ago

     

     

    The requirement is different. Sorry for the confusion.

     

    There are 5 bar graphs, with just one bar representing count. When I click one bar from the a particular bar graph, it should update the table independent of other bar graphs. 

     

    The cross filter is only between table and one bar graph.

    Is that possible?

     

    Thanks

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      9 years ago

      I'm still lost. Can you help me understand if data source for all the tables/bar graphs on your report is same. Also can you put some screen shot to help it understand better. As much as I (everyone) like to help you but I'm having hard time understanding the requirement. Sorry , it must be me.

      • gree1502's avatar
        gree1502
        Icon for Helper II rankHelper II
        9 years ago

        Thank you for following up.

         

        Sorry for the confusion again.

         

        Below is the screenshot.

        There are 3 bar graphs for eg:

        All three representing count. Each of these bar graphs which increases/ decreases the count based on

        a filter which I think is irrelevant here.

        For now let us think the count is static on the bar graph.

         

        If I click on the any one the bar graph, the table should filter and show only those particular ID's.

         

         

        Eg: If I click on graph A, the count is 25. The table should only 25 values.

        I have seen that edit interactions should work for this type of requirement, but it isn't working.

         

        Any help appreciated!

        Thanks