CODEWITHSUNDEEP
settableau-apicalculated-field
Seef
Seef

Reputation: 35

Combining dimension values to create an additional dimension value

I have a simple sample data set:

Name    Database    Amount
Brian   DC1          50
Brian   DC2          100
Steve   DC1          34
Bill    DC2          90
Ed      DC1          49
Suz     DC2          82

I'm struggling to create a calc or formula to combine "DC1" and "DC2" so that it says both. I'd like to ultimately be able to filter on "DC1", "DC2", or "Both"

Pushing this logic down to the to a sql case statement isn't feasible.

Is this possible to perform? Should I be creating sets and then using combined sets?

Upvotes: 1

Views: 40

Answers (1)

Sam M
Sam M

Reputation: 4166

Create a level-of-detail calculated field to see how many distinct database names each account has. Your code will look something like this.

if {FIXED [Name] : countd([database])} > 0 then 'Both' else [Database] END

Upvotes: 1

Related Questions