Forum Discussion

Arminx's avatar
Arminx
Frequent Visitor
9 years ago
Solved

Use filter but avoid propoagation effect

Hola,    I'm trying to calculate how much an employee is spending time on actual projects: 'productivity' = [total hours worked on projects] / [total hours that the employee was available] I'm ...
  • Arminx's avatar
    Arminx
    9 years ago

    I created a new AllDates(id, date) table with 1:* relationship with Tornado and 'public employee_schedule' on date column.

    In my page, I use AllDates.date for filtering, which propagates to both Tornado and public 'public employee_schedule'.

     

    Finally I use Format > Edit Interactions to avoid any other unwanted filters/slicers affecting my measure (that is shown in a KPI card).

     

    Thanks guys for the help.