I have 2 different data sources. In the first data source, each row looks like...
ID #, Name, Date, Quality, Color, [some more descriptions]
In the second data source, each row looks like...
Name, Date, Hours
In the first data source, there are multiple ID #'s per Name and Date (i.e. for Name "A" and Date "Dec. 1", there can be several rows). However in the second data source, each Name and Date combination corresponds to a single Hours entry. Example below: Name Date Hours
A Dec. 1 8
B Dec. 1 6
A Dec. 2 8
I would like to be able to create a table that displays COUNTD([ID #]) / SUM([Hours]) where I can filter by Name and Date. When I put this calculation into the details pane, it turns red and no value is returned.