Anybody have a good solution for an indicator card that shows which days are missing data (sales)?
I am trying to create a card that will show which dates in the past 7 days are missing sales data. I am sure the solution is a combination of dataflow work and creative card usage but just seeing if anyone had either already solved for this or had an idea of how.
Comments
-
In some cases like this you have to join your sales data with a calendar dataset that has all days in it. That way you'll have records of days with no sales data, but at least something is there when you have no sales.
Luckily the horizontal line and bar charts are pretty good at representing the same thing without that extra work.
Take, for example, a chart I have attached with employee punch data. Nobody worked Sunday but the chart still shows the day. This would be a pretty simple example of what you could do.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有