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.
For Example:
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!
Answers
-
@gilbec01 You could append the leads created and demos scheduled in a dataflow and rename their respective date fields to be called "Date". In this scenario then you can create a constant column to each sub-table called "Activity Type" with a value of "Create" or "Schedule Demo" before appending to differentiate between activities. To calculate conversion rate using the new dataset, you can base your card off of the "Date" column and write a beast mode like the one below:
sum(case when `Activity Type` = 'Schedule Demo' then 1 else 0 end) / sum(case when `Activity Type` = 'Create' then 1 else 0 end)
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive