Skip to content

    • Archive

    Archive

    Dynamic filtering based on date selections

    Member
    in Archive

    Hey all, Is there anyway we can display the metrics based on the user selections?

    Like I have to display the difference between 2 Forecast Sales, based on the user selection of the timeframe(2 calendar dates).

     

    It should work dynamically based on User input range? Any way to achieve this?

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Contributor

      If I am understanding your problem correctly, you could create a beastmode calculation with sum(forecast1) - sum(forecast2) and use it for the vaule. Then all the user would have to do is pick the date field to filter by and choose "is between."  

       

      - Brian


      **Please mark "Accept as Solution" if this post solves your problem
      **Say "Thanks" by clicking the "heart" in the post that helped you.
    • Member

      Hey Brian,

      The challenge here is the Forecast is the same database column, Its the difference of 2 values which can be calculated only at run time, I even thought of duplicating Dataset and creating 2 columns like Forecast1 & Forecast2, for which I need to do cross join and it will tax the performance..

       

      Hope you got the issue..

    • Contributor

      Unfortunately, beast mode does not currently support this functionality. Please see the below post for more information.

       

      https://dojo.domo.com/t5/Card-Building/Using-date-dropdown-to-manipulate-a-card-that-aggregates-using/td-p/28532

       

      Thanks,

       

      Brian


      **Please mark "Accept as Solution" if this post solves your problem
      **Say "Thanks" by clicking the "heart" in the post that helped you.
    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories