Dynamic filtering based on date selections

user07912
user07912
in Card Building

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?

Comments

  • Property_Ninja
    Property_Ninja 🟠

    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.
  • user07912
    user07912

    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..

  • Property_Ninja
    Property_Ninja 🟠

    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.

Categories