Dynamic filtering based on date selections
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
-
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.0 -
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..
0 -
Unfortunately, beast mode does not currently support this functionality. Please see the below post for more information.
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.0
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有