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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 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