I want to create a Table Chart to show the service level by month for this Fiscal Year.
I've created a calculation to get the service level --> (1-(SUM(`Lost Sales`)/(SUM(`Lost Sales`)+SUM(`Sales`))))*100
And now I want to calculate the Monthly Average of Service Level
In a line chart, I can manage it with date selection (graph by month), but with table chart, this option is not available, so this is a calculation I've created for Service Level AVG in January 2019 but it's not working (I didn't get any result):
case when CONCAT(MONTH(`Date`),YEAR(`Date`))=12019 then AVG(1-(SUM(`Lost Sales`)/(SUM(`Lost Sales`)+SUM(`Sales`))))end
Is that the correct way to do that ot there's other solution?
Thanks in advance.
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 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
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board