Want to track progression and targets based per Quarter

user046467

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

DavidChurchman

You need to aggregate Quantity in your Progress v2 Beastmode. Try:

'QUARTER(date) like 1 then (1250- (sum(quantity)))

DavidChurchman

You need to aggregate Quantity in your Progress v2 Beastmode. Try:

'QUARTER(date) like 1 then (1250- (sum(quantity)))

user046467

https://community-forums.domo.com/main/discussion/comment/95043#Comment_95043

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 screenshot

DavidChurchman

In your opening post, there is no sum() function around quantity. You tried it with that sum function?

user046467

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.