@v-viig @fraggle I'm still having this issue as well. I have a sample of data in my original post, but let's see if I can explain any better here. So I have the following 2 tables:
Categories
(Goal ID, Goal, Category)
2, goalA, categoryA
2, goalA, categoryB
3, goalB, categoryC
4, goalC, categoryD
Data
(Date, categoryAvalue, categoryBvalue, categoryCvalue, categoryDvalue)
2018, 5, 10, 7, 9
2019, 6, 12, 6, 9
So I need to associate the Goal ID fromm the Categories table to the rows in the Data table. But each row has a value for categoryA, categoryB, categoryC, and categoryD. So I can't assign one Goal ID to the rows in Data because it has a vaule for every Goal ID in the Categories table.
Even in the example data given on the app page (here) doesn't make sense, and it's the same problem. If you look at the table Column_Based_Metrics, and take the row from 9/1/2017, the ID column has the value 4, which would be the KPI Transactions in the Col_Links table. But the row has values for the KPIs Total Units (ID 1), Premium Units (ID 2), Gross Revenue (ID 3), Transactions (ID 4), Active Customers (ID 5), Avg Price (ID 6), Returns (ID 7), and Satisfaction (ID 8). So how is it determined that this row belongs with the ID 4 when it has values for every KPI? It seems as though every ID should be in that column since each has a value in the row.
Maybe I'm missing something?
