Combine Multiple Distinct Expressions Into One Table

Terra — Mon, 13 Jun 2022 17:41:50 GMT

I am creating a table where I am specifying every row with an expression. I am trying to specify multiple expressions in one table.

Sample Call Data:

Goal:

Note: I am using a table but looking at it from a pivot table point of view, Client, Metric, and SL are dimensions and Stat is a measure.

Here is the problem I am facing. The expression is not allowing me to display the same value if the expression is using the same argument.

Client:

IF(companyID = 1, 'Client A',

IF(companyID = 2, 'Client B',''))))...

Only 1 'Client A' is showing, not 3.

Is there a way around this? I have tried:

I don't want to split this into separate tables and stack them on top of each other to achieve this. I would like everything in 1 table.

The other columns will follow this logic:

Metric:

IF(companyID = 1, 'Avg connection time',

IF(companyID = 1, 'Avg connection time Spanish',......''))

topic Combine Multiple Distinct Expressions Into One Table in App Development