Want to track progression and targets based per Quarter
Hi all,
I've one datafile with sales with different products.
Quantity is a column where I used 'sum'
Target is made through a beastmode 'case when QUARTER(date
) like 1 then 1250 else 0 end'
Progress v2 is also made through beastmode and doesn't deliver the right results
'QUARTER(date
) like 1 then (1250- (quantity
))
else 0 end'
When I use sum(quantity) it creates multiple rows
The easiest way is probably to add a new column with the target to an ETL.
Problem is that I don't want to as it overcomplicates things and makes it harder to create a future proof progress column.
Hopefully there is another solution possible, thanks in advance
Best Answer
-
You need to aggregate Quantity in your Progress v2 Beastmode. Try:
'QUARTER(
date
) like 1 then (1250- (sum(quantity
)))Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Answers
-
You need to aggregate Quantity in your Progress v2 Beastmode. Try:
'QUARTER(
date
) like 1 then (1250- (sum(quantity
)))Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0 -
Thanks for your anwser.
Yes I tried that as stated in my opening post.
But then I receive multiple rows as you can see in the second screenshot0 -
In your opening post, there is no sum() function around
quantity
. You tried it with that sum function?Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0 -
I was referring to this, I used the same beastmode as you said.
I tried it again after your post but sadly same result where everything just becomes a new row.0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 636 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 701 Automate
- 182 Apps
- 457 APIs & Domo Developer
- 52 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive