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
Oct 27, 2020, 11:20 PM

Hi all - in the attached work book I'm trying to add a total column for the number of assessed risks for each country. I.e. for USA it's 4 assessed risks, for UK it's 3, for Germany it's 2 and for Brazil it's 1.

I also need a 2nd column for the nulls (i.e. number of non-assessed risks per country).

 

Looking forward to getting some help on this!

Counting applicable risks query.twbx
2 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Oct 28, 2020, 11:42 AM

    Hi Budi,

    Many thanks for taking a look at this, really appreciate it!

    Yes, I need to total the row instead of the columns, as you set out in your example above.

    Is it possible to also show a total for the nulls? i.e. for Brazil non-applicable risks = 3, Germany = 2, UK =1?

    Lastly, could you give me a high level overview of the logic of your calculation as I haven't come across this before?

    Regards,

    Sandeep

Write an answer...
0/9000