Programs Ending in the Next 60 Days
Hello Everyone, I'm trying to create a card that will show what programs we're running will end in the next 60 days. I think a beast mode would help accomplish my goal but I'm unsure of what to do. Each program has multiple billing dates associated with it so I need it to be based off of just the latest billing date.
Best Answers
-
Hard to say for sure without seeing your data, but something like this might work:
CASE WHEN DATEDIFF(MAX(billingdate),CURRENT_DATE()) < 60 THEN 'Program Ending'
ELSE 'All good'
END
You can then drag this into your filters and filter to Program Ending. Your table card would need to have your program name and then your billing date field and set to Max.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hi Mark! Thank you for your reply. I tried this and it didn't seem to work.
I used the Beastmode you created above:
CASE WHEN DATEDIFF(MAX(
Billing Month New
),CURRENT_DATE()) < 60 THEN 'Program Ending'
ELSE 'All good'
ENDI dragged it into filters and filtered for program ending. I have program names in my rows and I set the billing date field to max (date range is all time) but it's not filtering for dates from now +60 days. There's a bunch of old dates showing up. I attached a screen shot.
Thank you for the help!
0 -
To get rid of dates that are older than today, you would want to modify this statement to look like this:
CASE WHEN DATEDIFF(MAX(Billing Month New),CURRENT_DATE()) >=0 AND DATEDIFF(MAX(Billing Month New),CURRENT_DATE()) < 60 THEN 'Program Ending' ELSE 'All good' END**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Thank you so much! That worked perfectly. But now I have another question. I tried to add a couple more rows to my report (sales region and sales client) but I'm getting this error:
"An issue has occurred during processing. We are unable to complete the request at this time - 'undefined'"
There is no error when I take out those 2 rows.
0 -
Never mind! I think it was because I put the fields after the date field. I was able to make it work when I moved them. Thank you again for all the help!
0
Answers
-
Hard to say for sure without seeing your data, but something like this might work:
CASE WHEN DATEDIFF(MAX(billingdate),CURRENT_DATE()) < 60 THEN 'Program Ending'
ELSE 'All good'
END
You can then drag this into your filters and filter to Program Ending. Your table card would need to have your program name and then your billing date field and set to Max.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hi Mark! Thank you for your reply. I tried this and it didn't seem to work.
I used the Beastmode you created above:
CASE WHEN DATEDIFF(MAX(
Billing Month New
),CURRENT_DATE()) < 60 THEN 'Program Ending'
ELSE 'All good'
ENDI dragged it into filters and filtered for program ending. I have program names in my rows and I set the billing date field to max (date range is all time) but it's not filtering for dates from now +60 days. There's a bunch of old dates showing up. I attached a screen shot.
Thank you for the help!
0 -
To get rid of dates that are older than today, you would want to modify this statement to look like this:
CASE WHEN DATEDIFF(MAX(Billing Month New),CURRENT_DATE()) >=0 AND DATEDIFF(MAX(Billing Month New),CURRENT_DATE()) < 60 THEN 'Program Ending' ELSE 'All good' END**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Thank you so much! That worked perfectly. But now I have another question. I tried to add a couple more rows to my report (sales region and sales client) but I'm getting this error:
"An issue has occurred during processing. We are unable to complete the request at this time - 'undefined'"
There is no error when I take out those 2 rows.
0 -
Never mind! I think it was because I put the fields after the date field. I was able to make it work when I moved them. Thank you again for all the help!
0
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
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 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