You can do a count on the customer ID, status can be an attribute (or you use it to make 4 measures, one per status) and add a calendar dimension with all the days and you join it to your table with day BETWEEN time from AND time to.
You must not think SQL, that's not what OBIEE does, you must think model: the "number of" means a COUNT.
If you want to know the active customers you can do a count on the customer ID (or count distinct in case a customer can change many times per day) and filter your LTS by the "status = active" condition.
The FROM - TO is not an issue, you can make a join using a BETWEEN and you solved the issue (I guess you have a real calendar dim somewhere).
If no calendar dim you can also just filter in your analysis using the FROM and TO columns and adding a filter with the date you want.
+1 ! The important thing is to stop thinking in SQL and start thinking in models.
For your issue Gianni gave you the necessary inputs:
1.) a filtered LTS
2.) a BETWEEN join to a time dimension table
All of it sounds good however I'm not sure how to implement it.
Could you explain me more precisely how to do it? Especially I mean the part about making a join using between.
btw. yes, I have calendar dim.
In the physical layer when doing the join between your 2 tables instead of clicking 1 column from table A and 1 column from table B you edit the formula and write it using a 1 column from table A BETWEEN col1 from table B and col2 from table B, that's the only part that look a bit like the query you posted