Calculated field of two objects

Hi everyone,

I am trying to count the number of reports per site. Each report has a number of types (lets say: count, tank, etc).
However, there are some sites that each type of report should be multiplied. Thus, in sites a, b and c, each count report is equal to 1, in site d, it is equal to 3 (reports).
How do I create a calculated field that says: if report type = count and site name = d multiply by 3, if these two conditions are not met - leave it.
I tries with an ifelse statement but it was unable to conduct the calculation since my report type field (which is already a calculated field, is a STRING type.
I would opt or to change the string to some number so it can multiply or another approach would be great.


Have you tried parseInt to change your string to an Integer and us the result in your calculation?

Hope this helps!

Thank you very much but I tried it already and unfortunately it does not work

Hi @Etai, please try something similar to this:

    {Report Type} = 'count' and {Site Name} = 'd', 3,
    {Report Type} = 'count' and {Site Name} in ['a', 'b', 'c'], 1,

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it on a new thread – since this post is already 7 days old. (Details on using Arena can be found here - QuickSight Arena