We are trying to figure out if a customer has signed up for a service by determing if they have a certain charge on a pending invoice.
Product A = 1, 2, 3
Product B = 4, 5 6
Product A Category = Opening
Product B Category = Closing
Customers can have any combination of the above mentioned products and I need filters with a customer count for the following measurements.
Opened but didn't close (ONLY PRODUCT A BUT NOT PRODUCT B)
Opened AND Closed (PRODUCT A AND PRODUCT B - ANY COMBINATION)
Closed but didn't Open (PRODUCT B BUT NOT PRODUCT A)
Each customer has a customer ID as the unique idenftifier.
I have tried a few ways but I can't get the 2nd one to work (opened and closed)
= calculate ( distinctcount (customer id), filter ( category = "Opened > Opened - General" || " Closed > Closed - General")
I'm really lost how to make this work. Any help would be apprciated.