Forum Discussion

jd8766's avatar
jd8766
Icon for Helper II rankHelper II
4 years ago
Solved

Dynamic date slicer for 2 date tables?

Hello, I have a table that looks like the below... I have built a report using data from this table to show me the count of distinct contracts, and the sum of amount. This is controlled ...
Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    Hi again jd8766

    I have checked the link and Page2 it is now working.

    Sorry I had wifi refresh problems last night. 

    Please click the thumbs up and accept as solution buttons. Thank you ! 😀

     

    Click here to download an example 

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

I will answer this guys and send an example very soon.

I am answering an indentical question. 😀

 

  • speedramps's avatar
    speedramps
    Icon for Super User rankSuper User
    4 years ago

    Hi jd8766

     

    As promissed here is an example.

    Please click the thumbs up and accept as solution buttons. Thnak you ! 😀

    Click here to download an example 

     

    It is the same solution davehus has mentioned 😁

     

     

    • jd8766's avatar
      jd8766
      Icon for Helper II rankHelper II
      4 years ago

      This is really useful! Thank you for this.

      Is it possible to create a filter with one date field... and then another filter to populate this date field with either "start date" or "sold date"

      So I would have a drop down with 2 selections. One called StartDate and one called SoldDate

      If StartDate is selected, then my date slicer will filter the values on start date only.. and vice versa?

      • speedramps's avatar
        speedramps
        Icon for Super User rankSuper User
        4 years ago

        Hi again jd8766

         

        I have updated my example with a dynamic value on Page 2

        Please click the thumbs up and accept as solution buttons. Thank you ! 

         

        Click here to download an example 

         

        It is the same solution davehus has mentioned.

        Both solutions are the same. Ive just meaning to crarete an example because this question comes up so often.