Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Show only ACTIVE Customers list

Hi,   I would like to comment an issue I am struggling with.   I have a Customer_Dim with Start_Date and End_Date by customer, and a group of Fact_Tables (Cases, Finance, etc) Example: Customer...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak 

     

    Thanks for you answer, but this is not what I need. I do not the count of customer (Job ID in your example). What I need is to see the list of “active customers (Job ID)” when I select a specific time frame.

     

    As you can see in your example, If I select June 2019, there are only 2 Job IDs as active, but the list in the table shows the full list from the Data Table. I would like to see the 2 Jobs IDs that are active.

     

    The same for the filter:

     

    Many thanks!

    Jose