Error in Data diff function
I wanted to find avg daily registrations rate for which the formula will be: on 11th March 2022, we take registration count from Jan 1st to march 11 2022/70. 70 is the which is the total number of days till date.
Formula I used:
(CASE When `Year` = CONCAT(YEAR(CURRENT_DATE()))
then COUNT(`Email`) end) /
DATEDIFF(CURRENT_DATE(),STR_TO_DATE('2021-01-01','%Y-%m-%d'))
There is no error shown, and formula is valid, still it is not working
Any help is highly appreciated.
Thank you
Answers
-
Since you're only looking at the number of days in the current year have you tried using DAYOFYEAR(CURRENT_DATE()) as your denominator (I'm assuming this is the case since you mentioned 70 days even though you have 2021 as the year)?
I'd recommend breaking down each component of your beast mode into it's own beast mode and using a data table to display the values. Break out your numerator and denominator. This is helpful to possibly identify any portion which would be causing your error.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi Grant, I found the issue..
Thanks :)
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 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