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
______________________________________________________________________________________________0
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 251 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有