Forum Discussion
Dividing a number on a Visualization Table when the data is imported.
Hello!! I have this table below and I was able to divide Total Emails by Headcount to get Emails Per Person in Transform Data (see table 1A below.). However, Total Calls Answered was importanted ...
AllisonKennedy
OK so I am getting closer thanks to your help!!
Here is the issue now, I cannot get Total Headcount to match the correct headcount. I also can't get the fact to work for it.
Here is what I have right now and it gives me too many headcount. SEe the table below that shows what the headcount should be.
This is what happens when I add fact to it:
The problem is that I have a a table that shows the headcount - can I create a measure that just outputs the numbers that are in the table???
Count gets me closer to the better number