Sum data based on several criteria
Hi All, I am new to Domo and trying to figure out how I can create a specific card looking at a few columns of my data. Overall, I am trying to search a particular day of the week (sunday in this case), then search for a certain criteria on that day, then add up the unique count. However, I am not sure if a beast mode calculation is the way to go with that. Here is what i tried
IF weekday(1)If WEEKDAY(1) and `SESSION PURPOSE` = 'FULL_STORE_SCAN' and `REGION CODE`= 'NA' and `REGION CODE`= 'AP' then COUNT(DISTINCT `STORE NO`)
I have also tried this as well:
when `SESSION PURPOSE` = 'FULL_STORE_SCAN'
when `REGION CODE`= 'NA'
Then COUNT(DISTINCT `STORE NO`)
Neither is a successful calculation unfortunately. Thanks in advance for any help / suggestions / tips. I really appreciate it.
- 10.7K All Categories
- 13 Getting Started in the Community
- 38 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 119 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board