9 Replies Latest reply on Feb 5, 2019 11:20 PM by Mohammad Salman Khan

    dual axis map filter not working correctly

    Paul Hunt

      Hi guys,

       

      I am having several problems regarding filter with my dual axis map. It would be great if anybody could help.

       

      So here is my dashboard below.

       

      I want to be able to:

      (a) filter all charts by clicking a year on the line chart

      (b) filter all charts by clicking a bar on the bar chart

      (c) filter all charts by clicking on an airport bubble

      (d) filter all charts by choosing an airport on the drop down
      (e) filter all charts by clicking on a state(f) filter all charts by choosing a state on the drop down

      Screen Shot 2018-09-04 at 01.38.32.png

       

      (a), (b) and (d) work fine.

       

      However for (c) when I try to click on an airport bubble, my other charts disappear:

       

      Screen Shot 2018-09-04 at 01.39.55.png

      Similarly, for (e), my other charts disappear.

      Screen Shot 2018-09-04 at 01.46.41.png

       

      As for (f), when selecting a state from the drop down, although it filters the map, the rest of the charts do not change from their original level

       

      Screen Shot 2018-09-04 at 01.40.25.png

       

       

      Any help on any of the problems is hugely appreciated.

       

      I have attached my workbook.

      NOTE: I AM USING TABLEAU PUBLIC - workbook can be accessed here: Tableau Public

       

      Cheers,

       

      Paul

        • 1. Re: dual axis map filter not working correctly
          Sasha Hanna

          Hi Paul,

          The actions were conflicting with each other, my advice is to separate the two different levels filters on the map.

          1. Create an action filter for each element separately, so one for the bar chart and another for the line chart.

          2. Set up action for filtering on state:

          3. Set filtering action on Airport Code 1 (I noticed you were referencing Airport Code, it has to match the field you are using on the map).

          Hope this helps!

          Cheers,

          Sasha

          1 of 1 people found this helpful
          • 2. Re: dual axis map filter not working correctly
            Nitin Paighowal

            Hello Paul,

             

            This issue is due to State marks and Airport marks on same dual axis map.

            When you click on any airport code lets say LAX (in California), then state and airport come in action filter

             

            State is null for Sheet 13

             

             

            Solution:

            Edit your action filter since they are taking all the fields:

             

            1. Go to Dashboard -> action

             

            2. Edit the action filter 2 and add a new filter field "Airport Code1"

            Click Ok

            Now you will see Target sheets have filtered values

             

            For State filter, add a new filter:

             

            Also make sure drop down filter has relevant target sheets:

             

            Hope this helps. Please mark it as correct answer if it helped resolving your query

            3 of 3 people found this helpful
            • 3. Re: dual axis map filter not working correctly
              Paul Hunt

              Fantastic! Thank you so much Nitin.

              1 of 1 people found this helpful
              • 5. Re: dual axis map filter not working correctly
                Mohammad Salman Khan

                Hi ,

                 

                Great post to illustrate step by step procedure.

                 

                I am having a similar problem.

                 

                I am having a dual axis map, with Country and Offices on each layer respectively.

                 

                The way you explained to edit the dashboard action works fine for country.

                 

                But, I when I add the Offices as another filter in dashboard action it doesn't work. I can see the filter added on the dashboard action list, but it not visible on the respective sheets' filter actions. I can only see 'Country' action.

                 

                When I am adding the action (for office) , a small warning is showing saying 'missing values present' . Could it be the reason ?

                 

                Am I missing something? 

                 

                Regards,

                Salman

                • 6. Re: dual axis map filter not working correctly
                  Sasha Hanna

                  Hi Salman,

                  Add the Offices field to the worksheet you want to filter on Detail in the Marks card. The error you are getting is because Tableau doesn't have that information unless it is used as a field.

                  Hope this helps.

                  Cheers,

                  Sasha

                  1 of 1 people found this helpful
                  • 7. Re: dual axis map filter not working correctly
                    Mohammad Salman Khan

                    Hi Sasha,

                     

                    Thanks for providing inputs and explaining the reason behind it.

                     

                    I was able to achieve the filtering action. But, I used lat/long fields in the filter columns instead of office address field.

                     

                    I am new to tableau so pardon me if this is a silly question.

                     

                    Below is my sheets
                    1) map sheet -> which has for office(custom) and country(auto-generated) respectively in dual axis. OfficeAddress field in toolTip

                     

                    2) another sheet -> having slicing done by country and officeaddress.

                     

                    So, I was earlier trying to add officeAddress field in dashboard action filter, it was not working. But, I added lat/long custom fields for officeAddress and it worked.

                    Can you please help me as to how it worked ?

                     

                    Regards

                    Salman

                    • 8. Re: dual axis map filter not working correctly
                      Sasha Hanna

                      Hi Salman,

                      Do you have the custom lat/lon fields in both worksheets? It would good to see how you set up your workbook to explain exactly. Originally you were trying to filter from a lower or more granular level of detail (office) to a worksheet which did not contain that level information. Since you added the custom lat/lon which correspond to offices, Tableau now knows how to filter to those specific points.

                      Hope this clarifies.

                      Cheers,

                      Sasha

                      1 of 1 people found this helpful
                      • 9. Re: dual axis map filter not working correctly
                        Mohammad Salman Khan

                        Hi Sasha,

                         

                        Thanks for replying to my query

                         

                        I do not have custom lang/long on the worksheet which I am looking to filter based on the selected country/office on geo worksheet.

                         

                        I think I am missing some basic concept here.

                         

                        Sorry, I am not sure if I can share the workbook hence will try to describe my workbook setup.

                         

                        1) Geo Dual layer map workSheet :
                        Having Country on one layer ( added country field on color and details marks card) .
                        For second layer. I have custom lat/long on details card, some metric on color and size marks card and for labels I have country and officeAddress in tooltip.

                        As dataSource filters : Country, City , officeAddress

                        2) second workSheet: Simple bar graph. Having country and officeAddress slicing the data.

                        As dataSource filters : Country, City , officeAddress

                         

                        For Dashboard :

                        I have set up GeoMap worksheet as a filter.
                        N dashboard actions has 2 filters viz. 1)Country 2) Custom Lat/Long

                         

                        with this set up I am able to filter. But when I have officeAddress in place of Custom Lat/Long it doesn't work.

                         

                        Also, I was looking to implement additional feature where I can select one country US and office from China and filter barChart sheet on this selected filter. So, for that I tried adding one more action filter as a combination of country/lat/long , but it doesn't work as expected. Instead it ends up messing up the previous two actions as well.

                         

                        Regards,

                        Salman