Avg. Created Opportunities

user01600
user01600 Member
in Magic ETL

Hi,

 

I'm trying to create a Beast Mode calculation that will let me see the average opportunity by month (distinct by year) over all time (not actually broken out by month, but by individual who created them).

 

Currently I have this, which counts as several years being the same month. How do I group them easily to be distinct? i.e. Jan 2016 is distinct from Jan 2017

So:

COUNT(DISTINCT`License Sales Opportunities-Id`)/
count(DISTINCT Month(`License Sales Opportunities-CreatedDate`))

 

Thank you!

Best Answer

  • BlueRooster
    BlueRooster Domo Employee
    Answer ✓

    In the last distinct count, if you replace the month with something like this to capture year

    Concat(Month('Sales'),Year('Sales')) 

    That should allow you to keep your months distinct between years.

     

    Let me know if you have any other questions,

    Valiant_Ronin

Answers

  • BlueRooster
    BlueRooster Domo Employee
    Answer ✓

    In the last distinct count, if you replace the month with something like this to capture year

    Concat(Month('Sales'),Year('Sales')) 

    That should allow you to keep your months distinct between years.

     

    Let me know if you have any other questions,

    Valiant_Ronin

  • user01600
    user01600 Member

    Worked like a charm, thanks!

Categories