Forum Discussion
Solved
Can't Get KPI Visual to work with Multiple Tables
I have a table "Current Data" that contains Labour Hours and Name, and receives multiple entries per day per name (10 line items might have 1 hour each, so total time for that person for the day woul...
I actually solved this just now, using a new visual calculation and calculating the RUNNINGSUM.
DataInsights
Super User
Super User
Try creating a Person table that contains all names in the other two tables. Then create a relationship between the Person table and each of the other two tables (Current Data and Available Hours). It's best to avoid joining fact tables together (join dimension tables to fact tables).