2 Replies Latest reply on Apr 5, 2018 12:00 AM by Preetam Jawaria

    How to set default value selection in Action filter in Dashboard ?

    Preetam Jawaria

      Hi Everyone,

      I have five different objects on a dashboard.
      Object 1 (Country) – contain some list of values.
      Object 2 (City) – contain some list of values.
      Object 3 (Customer Name)– contain some list of values.
      Object 4 (Order ID) – contain some list of values.
      Object 5 (Date) – contain some list of values.

      The Action filter is applied as –
      Click on any value of object 1 -  will affect objects 2,3,4,5
      Click on any value of object 2 -  will affect objects 3,4,5
      Click on any value of object 3 -  will affect objects 4,5
      Click on any value of object 4 -  will affect object 5

      My Requirement is when I click on any value of object 1 (Manually) , then
      By default corresponding first value of object 2  , first value of object 3 , first value of object 4 should get selected already so in result some values of object 5 will appear.

      I have attached the sample dashboard.
      Thanks in Advance..!!

        • 1. Re: How to set default value selection in Action filter in Dashboard ?
          sudheer.kumar.5

          Hello Preetam,

           

          Can you attach the workbook?

          • 2. Re: How to set default value selection in Action filter in Dashboard ?
            Preetam Jawaria

            Hi Sudheer,

             

            I am trying this in my organization , so I am not allowed to upload the file due to firewall.

            The scenario is exactly same as I explained, it would be really great if I get help on this.

            This is the critical requirement client is looking for.

            For a pictorial view , this how the final look is :

            Requirement Example.jpg

             

            So the Action filters are set as :

            Click on Country -                will affect City, Customer name , order ID, Order date

            Click on City -                       will affect Customer name , order ID, Order date

            Click on Customer name -  will affect order ID, Order date

            Click on Order ID -               will affect Order date

             

            Whenever I click on any country , then by default corresponding 1st city of clicked country ,

                                                                                                                           1st Customer name of first city,

                                                                                                                           1st order id of first customer name ,

                                                                                                                           1st order date of first order id should be selected

            Requirement Example.jpg

             

            Thanks

            Preetam