Set analysis based on value of a field in a straight table

[bronsonelliott]

Below is a sample of my data set:

Metric	Value
Metric 1	10%
Metric 2	20%
Metric 1 #	50
Metric 2 #	20

You'll notice that there are 2 metrics with a percentage value and 2 with a numeric value.  The % metrics and # metrics are related to each other.

I have a straight table where I was to display the % metrics along with the # metric value in parenthesis

for example

Metric	Value
Metric 1	10% (50)
Metric 2	20% (20)

I can easily create the straight table with the Metric and the % value but I can't seem to zero in on the correct syntax for the set analysis for the portion in parenthesis.  This formula should be based on the metric name plus the "#". 

One more added complexity, I want all of the values to show in the straight table at all times regardless if someone happens to click on one of the metrics (so it basically needs to ignore the current selections as part of the set analysis).

Hoping this is enough to go on for someone.  I don't have a simple version of my application to share as this time.

Thanks!

Bronson

[#2]

Hi Bronson,

you can use the concat function to achieve this, please see attached

hope that helps

Joe

[bronsonelliott]

Not sure that's going to work because the sample I gave is very simplistic.  The real data is much bigger with a few other elements to the data such as Country, etc.  So the numeric value would need to be aggregated.  Does that change the answer?

[#4]

Yes it most likely would, helpful if you could upload an example or provide a bit more basic data to work with

thanks

[ramoncova06]

you do know that the best way to do this is to modify your backend and instead of having "metric #" and metric have a value and a value %  and then just concatenate the values