Getting an SPC card to track data by the Day
I have an SPC (Statistical Process Control Chart) card that's been built that doesn't seem to want to display the data properly. It's a card to keep track of our Covid19 positive colleagues.
So the way it's built is with test date on the x axis from the data set in the form of date field and the y axis is beast calculation to sum positive results from the dataset aka (case when 'test result' = 'positive' than 1 ese 0 end). The only filters are for test date greater than 1/1/2022, test results Not In, and test refused not in "Y".
So it builds out the chart but the only problem is despite choosing for it to show data for "This year" and to show it by day. It's displaying the x axis as a type of hourly from January 1st in 4 hour intervals aka January 1st 12am, 4am, 8am, ... etc.
Anyone know what could be causing this and/or if this is an error on DOMO side of things in terms of card function?
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部