Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

FROM and TO Dates selection

Hi,

I have a dashboard having many Kepy Figures along with Monthly view, Yearly view and so on..

 

My source file has a created date and my users are asking me a have a selction filter on date. Users wants to select or enter the from and to date, so that my dashboard should show which falls between from and To dates. But both these from and To dates are using the same created date, what I did I have created two columns and named as From and To Date, added these two columns as filters.

 

When I select some date in FROM the same date is considering in TO filter as well, but I don't want like that.

 

My dashboard should display the data which falls between two dates.

 

ex: If I select FROM: April 2015 and TO April 2016 and dashboard should reflect the data between these two dates.

 

Can anyone implemented like this.

 

Appreciated your support.

 

Thanks,

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    In your filters, you need to select for your From the "is greater than" condition and for the To the "is less than" condition and tell your users not to mess with it but just change the filter dates.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      But my FROM and TO fields are pointing to the same field, that is the tricky here and I have seen slider visual gallery that is working fine but that has lot if bugs.

       

      Thanks,