Calculated field of two objects

Question & Answer
,
1

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.
Thanks

2

Hi,

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

Hope this helps!

3

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

4

Hi @Etai, please try something similar to this:

ifelse(
    {Report Type} = 'count' and {Site Name} = 'd', 3,
    {Report Type} = 'count' and {Site Name} in ['a', 'b', 'c'], 1,
    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