Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having in my datamodel one central transactional data / fact table, with Calls from employees.
Connected with this fact table is a master calendar which is connected to the date of these Calls.
Now I would like to build in the frontend a table for each employee which gives out the "amount of days per selected time period".
I have tried it with the formula count(distinct date), what happens it shows the amount of days (where each employee had Calls). But I would like to see the amount of days which are given in the selected time period, disregarding the calls.
Than I tried to use count( {<Name=, [Country Code]=>}distinct date), to disregard the calls, but that did not work out.
Does anybody have an idea, how to count ALL days in the calendar, per selected timeperiod but disregarding the calls ?
I have not selected anything, in my table there are just 2 fields (employee, country) and this one measure [count(distinct date)].
I already tried to exclude the dimension employee / country: count( {<Name=, [Country Code]=>}distinct date)
But it did not work. The count(distinct date) shows me the amount of days where the employee did calls -´due to relationship between my calendar and the fact table. But I just want to display the amount of days / how many days has the selected time period (Jan to March 2019, 91 days).
I need to blend out the relationship from both tables, in this special case. But dont know how to do.