Forum Discussion

taylorb's avatar
taylorb
Helper I
6 years ago
Solved

Trying to Count Status Using Two Date Columns

I am trying to find the status of products based on whether or not the date selected is between two date columns. Here is an example of the data:

 

ItemManufactured DateIn Service DateOut of Service Date
Product 11/1/20201/25/20202/6/2020
Product 21/23/20201/27/20202/10/2020
Product 32/3/20202/5/20203/1/2020
Product 42/1/20204/7/20204/15/2020

 

If I looked at a date, I want one visual for count of items in "Manufactured" (not yet in service) and a different visual for "In Service" (not yet out of service). So for the above data, if I looked at 2/5, I would have Product 1-3 "In Service" and Product 4 in "Manufactured"