Average if channel type statement beast mode
I am trying to create a summary number that takes an average of one customer type and compares it to another.
My code currently looks like
(CASE when `Channel` = 'RET' then SUM(`ordercases`)),' | '
(CASE when `Channel` = 'FSV' then SUM(`ordercases`))
I am having trouble with the syntax. Has anyone had any experience with this?
Update I figured out the code to get it to work
(SUM(CASE when `Channel`='RET' then `ordercases`end)),' | ',
(SUM(CASE when `Channel`='FSV' then `ordercases`end))
Would it be possible to put a custom calculation at the beginning and get it to work too?
The equation I would like to put in front would be sum(case pick)/ sum(order cases) so basically getting an overall average
- 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
- 501 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board