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, 2022 in Tableau 409 views

## 1 answer to this question.

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])
• 9,060 points

## How to dynamically determine and categorize duplicate value in Tableau?

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

+1 vote

## Instead of using tableau server can't I just install tableau desktop and connect it to required database?

There are multiple ways for connecting to ...READ MORE

## Measures and dimensions in Tableau

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

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

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

## How to implement constants in java

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

## NaN variable without NumPy

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

## How to declare constants in python?

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

## Using Python and Tableau in conjunction with one another

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