Forum Discussion
Visual filtering
Need a bit more information. Can you share sample data screenshots and what exactly the measure is showing and what you expect to see
I'll put together a sample and add it to this message, I can't do real samples as its confidential data. so will do a mock up
ok so here is a sample of what i've built so far:
Main Data Table Customer Utilisaton Emp Name 1 Emp Name 2 Cust 1 10% Joe Bloggs Cust 2 15% Jane Bigs Joe Bloggs Cust 3 10% Joe Bloggs Cust 4 20% Jane Bigs Joe Bloggs Cust 5 10% Jane Bigs Cust 6 15% Jane Bigs Employee table 1 which has a relationship to Data Table Emp Name 1, this runs a calculation that looks for the Emp Name in the data table Emp Name 1 column and then sum the utilization associated. I've also used it to bring through the results from a second table and create a total (this is the part I want to change)
Emp List table 1 Emp Name1 Utilization Emp 2 Utilization Total Utilization Joe Bloggs 20% 35% 55% Jane Bigs 60% 0% 60% Employee Table 2, has a relationship with Data Table Emp Name 2, does the same as the first table simply calculates the utilzation based on finding the name in Emp Name 2.
Emp Table 2 Emp name2 Utilzation Joe Bloggs 35% Ideally I want to have one Employee table that does the calculation for all the utilization, but I can't work out how to have that work when I need to look in two different columns. (Emp Name 1 and Emp Name 2). and its not possible to combine the two as the names are the same and the reason for them being there is different.