Tableau - Calculating and presenting epidemiologic Incidence and Incidence Rate 10 000

0 votes
In Tableau server client i can able to print the site id based on the site id i need to print project and workbook.In the above code the user get the list of siteid's belongs to his role the user select the site id and i have stored in object "i" based on the site name how can i drill down to project and workbook.
Mar 4 in Tableau by Vaani
• 5,040 points
16 views

1 answer to this question.

0 votes
It appears that an aggregate calculated field or a level of detail (LOD) calculated field is required.

SUM([Incidence]) / SUM([Incidence]) / SUM([Incidence]) / SUM([Incidence]) / SUM([Incidence]) / SUM([Incidence] ([Population]) Instead of computing a ratio for each record and then adding the ratios, this algorithm computes the sums first and then divides them. When working with ratios, this is frequently required.

Furthermore, I assume your Population data don't change every day, therefore aggregating them with Sum() as seen above will inflate the denominator. In such instance, you'll need to use a LOD calculation to determine the population at a different level of detail. In that situation, a formula like this may be used.

MAX([Population]) / SUM([Incidence]) / FIXED [State], [County]: MAX([Incidence])
answered Mar 10 by Neha
• 6,260 points

Related Questions In Tableau

0 votes
1 answer

How to dynamically determine and categorize duplicate value in Tableau?

Apparently you define a duplicate records as ...READ MORE

answered Apr 13, 2018 in Tableau by xyz
• 1,560 points
5,627 views
0 votes
1 answer

Measures and dimensions in Tableau

It is basically categorical and quantitative data. ...READ MORE

answered Apr 27, 2018 in Tableau by QueenBee
• 1,820 points
448 views
0 votes
1 answer

Is it possible to merge year, month and date in Tableau?

Remove all the date pills and drag ...READ MORE

answered May 10, 2018 in Tableau by sdfg
• 5,550 points
869 views
0 votes
1 answer

How to implement constants in java

Here is the solution- public static final TYPE ...READ MORE

answered May 28, 2018 in Java by sophia
• 1,400 points
135 views
0 votes
1 answer

NaN variable without NumPy

Yes, It is possible to use the ...READ MORE

answered Nov 26, 2018 in Python by SDeb
• 13,300 points
690 views
0 votes
2 answers

How to declare constants in python?

In python we don't require to declare ...READ MORE

answered Aug 18, 2019 in Python by anonymous
• 460 points
278 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
48 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP