Beast Mode for same date check
I have a list of companies and their create date. I want to create a beast mode that checks if a list of companies has the same create date. Any help here?
Would this need to be done in Magic ETL?
Best Answer
-
Hmm the way I would do this is still in MagicETL. I would convert the timestamp using a formula tile with the following formula:
CONCAT(DATE_FORMAT(`Date`,'%m/%d/%y %k:'),(CEILING(DATE_FORMAT(`date
`
,'%i') / 5) * 5))Then follow the same process I mentioned earlier, but use this field instead of your date field. What this will do is group everything to the nearest 5 minutes. So if you have a company created at 12/01/2023 8:15AM and another at 12/01/2023 8:13AM they will be grouped together.
If I solved your problem, please select "yes" above
2
Answers
-
You can create a pivot table with the rows field as created date, and a second rows field as the company name. This will give you all companies by creation date. You will need to put a dummy value into the values box so that the chart will render. you can just do a count of rows, it does not matter since its a dummy column.
0 -
Let me rephrase. I want to create a beast mode filter that will allow me to see only companies that are created minutes apart
0 -
Using MagicETL you could use the group by tile and choose your create date as the column that identifies the grouping. Then select "Add Formula" and use GROUP_CONCAT(`Company`). The output will be a comma separated list of companies for each create date.
It would be helpful if you could share what kind of output you are looking for and how it will be used.
If I solved your problem, please select "yes" above
0 -
@ColemenWilson Is there a way to do this in Beastmode? For example, I have a list of 20 companies and the create date (is a timestamp) per day, and want to discern which have been created around the same time
0 -
Hmm the way I would do this is still in MagicETL. I would convert the timestamp using a formula tile with the following formula:
CONCAT(DATE_FORMAT(`Date`,'%m/%d/%y %k:'),(CEILING(DATE_FORMAT(`date
`
,'%i') / 5) * 5))Then follow the same process I mentioned earlier, but use this field instead of your date field. What this will do is group everything to the nearest 5 minutes. So if you have a company created at 12/01/2023 8:15AM and another at 12/01/2023 8:13AM they will be grouped together.
If I solved your problem, please select "yes" above
2 -
I'll try this out! Thanks so much @ColemenWilson
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive