Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jul 29, 2020, 1:55 PM

Need your help guys! I need to calculate the incidence rate of number of workers fired /total firm's employees. I have to use this info within a city map of a Region .

 When I create a calculation filed tot_fired/tot_employees, the results is correct (table) but when I plot the map the incidence rate is wrong because I think there are firms that appear multiple times during the days I'm analysing. I've tried LOD but nothing is workin. I'm sharing with you a workbook with the example and the results I want to have! Thank you for your help in advance

INCIDENCE RATE.twbx
2 answers
  1. Jim Dehner - Tableau Visionary HoF (Market Analytics LLC)
    Jul 29, 2020, 3:50 PM

    Hi

    see the attached - it uses this

     

    sum({ FIXED [City]:sum([Fired])})/sum({ FIXED [City]:sum([Total Employee])})

     

    and will return this

    Hisee the attached - it uses this sum({ FIXED [City]:sum([Fired])})/sum({ FIXED [City]:sum([Total Employee])}) and will return this If this posts assists in resolving the question, please mark it as “

     

    If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote. 

    Also please help use better track your reply by including a mention to the volunteer who provided the answer  – mine is   @[Jim Dehner]​ 

    Thank you.

    INCIDENCE RATE_v2019.1.twbx
Write an answer...
0/9000