0 votes
1 view
in BI by (17.6k points)

I have a simple COUNTIF task in Excel that is proving rather difficult to replicate in Tableau...

This is the data:

ID   Metric   Scope   DynamicCalc

1    A1       TRUE    X

1    B1       FALSE   X

2    B1       TRUE    X

2    A1       FALSE   X

2    C1       FALSE   X

The column 'DynamicCalc' should have the following values when Metric=A1 is selected: TRUE,TRUE,FALSE,FALSE,FALSE but if say B1 is selected it would be FALSE,FALSE,TRUE,TRUE,TRUE... so basically I want to assign a value of TRUE to the DynamicColumn if there is at least one TRUE in the Scope column to all rows for that ID. 

Please log in or register to answer this question.

Related questions

0 votes
1 answer
asked Aug 1, 2019 in BI by ashely (43k points)
0 votes
1 answer
asked Oct 8, 2019 in Python by Sammy (47.8k points)
0 votes
2 answers
Welcome to Intellipaat Community. Get your technical queries answered by top developers !