Forum Discussion
Visual filtering
I created a new filter, basically there is an issue with where it is pulling the data.
I have two tables both with the ID of Name, I have them both linked to the main data table as a relationship but it appears as though this isn't working correctly
the only reason I hav two tables in the first place is because I can't get a calculation to work in the main employee table. the table has a column for names, but there are two corresponding columns in the main data table. so the relationship that I have is between the Table-Name column and the Data-name1 column. so my second formula which is meant to check the Data-Name2 column, is the one that isn't working.
so I created a whole new table, created the relationship and then the formula worked. but now its not showing the right customer details in the visuals. if I could somehow get the formula to work then I could get rid of the second table and the problem would be solved.
the formula I wrote as a measure is:
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.