Counting Dates on a date rage
In my business we sell a monthly service. A customer is either acivated or deactivated. I have a dataset that has 2 date columns (activation date and deactivation date). I can easily create 2 separate cards that show the number of activations and deactivations every month. The activation card would have the activation date (X axis) and count of activation date (Y axis). However, I want to combine those 2 cards so that I can see the number of activations every month compared to the number of deactivations every month. How do I do this with the Date Rage Field \ X axis being restricted to one of those 2 dates?
Best Answer
-
Hi Jferrara,
You'll need to do some sql on the backend (at least that's what we've done) that essentially adds a new line for every month that a customer is active with a count of 1. Then, when the customer is listed as deactivated, it returns a value of -1. This way, you'll have a new field of Customer Status, and your customer will be listed as "Active" every month until they are deactivated, where their status will then change to "Inactive". We used the mysql tool to write this code. Thanks!
1
Answers
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 726 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 29 お知らせ
- 65 Kowaza
- 302 仲間に相談
- 664 ひらめき共有