I know the name sounds convoluded, but it's a simple enough problem, I'm just having trouble getting it to work.
Say that table CLIENTS contains a record of clients, and table CALLS contains phone calls made to clients. They are linked by the 1-* (CLIENTS-CALLS) field, CLIENTID.
Now, I want to display a pie graph of the number of clients that have and have not been called in a given time period. This time period is defined by a slicer pertaining to the DATE field of the CALLS table.
So far I've got all of this last bit to work correctly. The pie chart is not responding to the slicer.
So far, I've been trying to use the results from a new column in CLIENTS:
I know, what if I'm approaching this the wrong way? Maybe the solution is to list the distinct CALLS[CLIENTID]s, count them, and then somehow count the remaining CLIENTIDs in the CLIENTS table. But how?