I want to change two KPI using a Date filter(date1) having date id as (date_id).
I have two KPI:
1. #Activated Users
2. #Transacted Users
On applying date filter, I want to see count of users who activated on that date in "Activated Users" kpi and count of users transacted on that date in "Transacted Users" kpi. I have activated_date for a user in user dimension table and transaction_date in fact table.
By this way, I am getting value of both kpi for a particular date. But these kpi shows "-" when I select multiple date from Date filter. I think comparison in set analysis is failing since I have selected multiple dates.
How do i get KPI values for multiple date ? I there something like WHERE IN in SQL which i can use to do this?