I have TOTAL as a calculated field on Tableau, which is further connected to R studio to create outputs through R

The R code has a function which is returning a bunch of 100 and 50 in a function passing .arg from Tableau, and these number will change if the parameter changes.

Calculated Field: TOTAL :

```SCRIPT_STR("
numbers <- function(a,b,c,parameter){
a <- as.numeric(a)
b <- as.numeric(b)
c <- as.numeric(c)
parameter <- as.numeric(parameter)
al = ifelse(a > ((parameter * b) + b) | a < (c - (parameter * c)),'100','50')
return(al)
}
numbers(.arg1,.arg2,.arg3,.arg4)
", SUM([A]),SUM([B]),SUM([C]),[PARAMETER])```

Now, once I visualize the result (in a Pie Chart), I am not able to get the how many 100's or how many 50's are in there, but it is dividing the number proportion properly.

Obviously the 100 in the first picture means one 100 of all the 100's that the output has, but I'd like to know the total of 100's and 50's

I tried to use COUNT over the TOTAL field, but it gave me an error that said TOTAL is already an aggregate function and it cannot be further aggregated.

Can someone help me to resolve this? Apr 5, 2018 in Tableau 3,031 views

## 1 answer to this question.

Create two calculated fields one for 100's and other for 50's

```if Total = 100
then 1
else 0
end```

For counting 50's

```if total=50
then 1
else 0
end```

Finally take the running sum for both the calculated fields and add both the formulas in tool tip answered Apr 5, 2018 by
• 10,240 points

## How can I calculate the median of sales price using 3 variables in Tableau

First let me clarify things for you. ...READ MORE

## How can I sort date field in presence of another date field in Tableau?

Goal: Sort the new ship date in ...READ MORE

## How to aggregate and count the occurrence of TRUE and FALSE?

Hi, you can do any of below ...READ MORE

## how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

## How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

## How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE