Comparing WTD Sales upto the current time for last 3 week
Best Answer
-
Hi, Prajju,
As with most of these things, there are several ways to do it, and the best option will depend on how you're trying to visualize the data. One way to do it is to create oneBeast Mode calculation that puts each record in a week bucket (e.g., current week, prior week, 2 weeks ago, etc.). That's the easy part.
Then, you'll also need to create a Beast Mode calculation that returns sales amounts for only those datetimes-of-week that are less than or equal to the current datetime-of-week. You can do that using the DayOfWeek(), Time(), and CurrentTimestamp() functions.
Essentially:
CASE WHEN [Transaction Day of Week] < [Current Day of Week] OR ([Transaction Day of Week] = [Current Date of Week] AND [Transaction Time] <= [Current Time]) THEN [Sales Amount] ELSE 0 END
Hope that points you in the right direction.
Dan
1
Answers
-
Hi, Prajju,
As with most of these things, there are several ways to do it, and the best option will depend on how you're trying to visualize the data. One way to do it is to create oneBeast Mode calculation that puts each record in a week bucket (e.g., current week, prior week, 2 weeks ago, etc.). That's the easy part.
Then, you'll also need to create a Beast Mode calculation that returns sales amounts for only those datetimes-of-week that are less than or equal to the current datetime-of-week. You can do that using the DayOfWeek(), Time(), and CurrentTimestamp() functions.
Essentially:
CASE WHEN [Transaction Day of Week] < [Current Day of Week] OR ([Transaction Day of Week] = [Current Date of Week] AND [Transaction Time] <= [Current Time]) THEN [Sales Amount] ELSE 0 END
Hope that points you in the right direction.
Dan
1
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 560 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 575 Beast Mode
- 13 App Studio
- 28 Variables
- 582 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 356 Distribute
- 95 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive