Forum Discussion

mwalden's avatar
mwalden
Frequent Visitor
2 years ago

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 ...
Need Help
mwalden's avatar
mwalden
Frequent Visitor
2 years ago

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???

mwalden's avatar
mwalden
Frequent Visitor
2 years ago

Count gets me closer to the better number

 

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    mwalden  - what's the 'Correct Headcount' coming from? Is it a column or measure? You should be able to use that in your divide. 

     

    The 'fact' was just my placeholder for the table name, so you can ignore that part of it-  sorry for confusion.