Working with Multiple Date Fields
I'm struggling to find a solution for creating things like conversion rates between metrics that are dependent on different date fields.
looking for the ratio of leads created (created_date) and how many demos were scheduled (scheduled date) in the same month.
It's important to note that the scheduled count is not a subset of the leads created. There could be leads created in the previous month that were scheduled in the month I'm looking at and I want to include those still.
I have separate beast modes for Total Leads and Scheduled Demos that work on their own, but when I combine the expression for each of them into one beast mode I see incorrect numbers because they individually refer to different date fields.
Has anyone ran into this or have any ideas of how to make this work?
Thanks in advance!
- 7.3K All Categories
- 13 Getting Started in the Community
- 134 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 52 Domo Everywhere
- 2K Charting
- 994 Ideas Exchange
- 895 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 18 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 570 日本支部