Want to track progression and targets based per Quarter

user046467
user046467 Member
in Beast Mode

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'

image.png

When I use sum(quantity) it creates multiple rows

image.png

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

  • DavidChurchman
    DavidChurchman Coach
    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.

Answers

  • DavidChurchman
    DavidChurchman Coach
    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.

  • user046467
    user046467 Member
    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
    DavidChurchman Coach

    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.

  • user046467
    user046467 Member
    image.png

    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.

Categories