Group on account name

Hi,

 

I am new to Domo. I currently have a card using Salesforce data that shows the average deal size per opportunity type.

I can show this per month and per quarter per filter.

For example:

                             Account Name        Amount       Close Date              

Opportunity 1       Customer A               50                 24 Oct 19

Opportunity 2       Customer A               100               24 Oct 19

Opportunity 3       Customer A                20                24 Oct 19

Opportunity 4       Customer B               40                 14 Oct 19

 

Now it averages them like this: 50+100+20+40 / 4 = 52.5

 

However I would like to group the customer A opportunities that are on the same date as one.

So it average like this: (50+100+20) + 40 / 2 = 105

 

How can I do this?

 

Regards

Dorien

 

 

 

 

 

Comments

  • You can create a calculated field and use that as a summary number;

     

    SUM(`Amount`) / COUNT(DISTINCT CONCAT(`Account Name`,' ',`Close Date`))

    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
This discussion has been closed.