Beast mode to show only one month
Have a dataset for fire drills we have several locations that run them every month i want to create a beast mode to only show me one month so i can duplicate it for each month to show one column per month to see who didn't run their drills month to month this is what i have but it is not working i will show you an idea of how i want it to look any help is appreciated
Best Answer
-
Did you copy and paste what I gave you? My formula validates
Your latest examples have multiple errors with missing an END statement and incorrect quotes. Try just copying and pasting what I gave you the first time.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
You can re-write your beast mode like this to make it work
(CASE when `Date` >= '1/1/2022' AND `Date` <= '1/31/2022' THEN 1 ELSE 0 END)
As currently, constructed, you will have to go back into this card once 2023 and update it. You may want to think about using the MONTH() function to determine the month and then use the date range filter to only show the last 12 months or so. This would keep you from having to regularly update the card.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
its not working i keep getting "invalid formula this calculation contained a syntax error
i thought it might be the way the data is in the data set as it comes over as Jan 1, 2022 so i changed it to that but still getting the error
(CASE when `Date` >= "Jan 1, 2022' AND `Date' <= 'Jan 31, 2022' Then 1 ELSE 0)
and tried
(CASE when `Date` >= "1/1/2022' AND `Date' <= '1/31/2022' Then 1 ELSE 0)
0 -
Did you copy and paste what I gave you? My formula validates
Your latest examples have multiple errors with missing an END statement and incorrect quotes. Try just copying and pasting what I gave you the first time.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Just use a pivot table card and put YearMonth (might need a beast mode) on the Columns axis and Locations on the X axis and make your metric the count
https://domohelp.domo.com/hc/en-us/articles/360043429473-Pivot-Table
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
MarkSnodgrass it did work but not the way i had hoped my fault not yours think i know what i need to do to get it work thank you so much everyone for your assistance
0 -
ok let me try to explain it this way i want one beast mode to show me only January entries, one beast mode to show me only February one for March excreta, so i will have 12 beast modes to have each of them as columns so we have a quick view of which locations have completed the drills each of those months
the above worked but each location had multiple rows with 0 because it pulled the entire year so far instead of only looking at January
I'm sorry thank you all for your help
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive