Making a Field to Calculate 'Yes' or 'No' Sales for last quarter
I am attempting to build a beastmode that gives me a value of ‘Yes’ if there is a “sale” in last quarter or a "no' if there isn't. Here is my code so far:
*‘End of Business Date’ acts as a current date function in our dataset.
The issue with this is that it does count all the rows from last quarter as a ‘Yes’, but if there is also a sale for the current quarter, it's counting it as a "No'.
As you can see all the 2023 dates have a “No” because I'm assuming it's only counting the latest date.
How can I change it so that it disregards the current date and directly looks at the last quarter date so that the function works properly?
Thanks!
Answers
-
There are several way to approach this, depending on how your dataset looks like and how you're configuring your card. Here is where using the
Graph By
option in the card can come a long way. You could use the date range by theCommitment Date
and Graph by Quarter, to know how many sales you happened on each quarter. Hope this helps (this will create an entry for each quarter).0 -
The Graph By wouldn't work in this case because I am trying to isolate the beastmode. There are other beastmodes that are all indicating different time brackets on that page.
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive