Sum(Distinct Value) Trying to get the sum of?
I've got a dataset that gives me an employee count and an employee count target by location.
When I view this by location it gives me the correct values with the target value coming from the following Beastmode:
SUM(DISTINCT `Target`)
The employee count comes from this Beastmode:
COUNT(DISTINCT `WRISEmployeeID`)
When I want to see this rolled up into a market however the employee count seems to roll up fine, but the Target value is rolling up to a value of 35 which appears to be the number of entries and not the sum value of the Beastmode, it should be more along the lines of 129.
I've tried a couple of methods using Case Statements etc but to no avail.
Any ideas?
Thanks
Randy
Comments
-
Is anyone able to help out with this request?
0 -
Hi Randy,
I have emailed you top get some more information on the card.
Thanks!I work for Domo0
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
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有