Need to combine two values from a field to a single value in the same field

[abc_18]

Hi,

I have a field say column with values as:

Column:

A

B

C

D

E

my requirement is to add two values together and make it as a single value in same column like below:

A

B+C as ' new name'

C+D as 'new name1'

E

please let me know how to achieve this.

[Mark_Little]

Hi,

Your not far from it already. 

LOAD

A,

B&C as ' new name',

C&D as 'new name1',

E,

From ...

If they are numbers then you can use the + to sum them instead of the &. 

[vinieme12]

best to Rangesum() to avoid issues with sum'ing null values

Column:

LOAD

A

,B

,C

,D

,E

,Rangesum(B,C) as newfield1

,Rangesum(C,D) as newfield2

From SomeDataSource;

[abc_18]

Hello everyone, thanks for the response.

I tried above but it's not working. may be the explanation was not clear.

Actually have a compliance column in a table and need to add two values from compliance column to show the count .

load

Compliance,

OS,

OS Type

from xyz;

in that Compliance column have these 6 values as A,B,C,D,E,F and need to show the combined count of B&C and E&F in a bar chart.

I know how to combine two diff fields but my question is how to combine a field values to make  one value and show the count in bar chart like below.

[vinieme12]

create a new field which groups values as below

Temp:

Load * Inline [

ComplianceType,Value

A,10

B,10

C,10

D,10

E,10

F,10

];

Grouping:

Load * inline [

ComplianceType,ComplianceGroup

A,A

B,B+C

C,B+C

D,D

E,E+F

F,E+F

];

Now use Dimension

=ComplianceGroup

Measure

=sum(Value)

[abc_18]

Hi Vineeth,

Thanks for the response.

but have a question what to provide in value column in first inline load.

My compliance column contains values like (Compliance, Not compliance, overall and so on.....) and against these I am showing count of machines in bar chart (expression)

[vinieme12]

whats important is the Grouping table 

Just make sure to group your dimension values correctly and Use the ComplianceGroup field in your chart

Your measures will automatically aggregate based in the grouped values

Dimension:

ComplianceGroup

Measure

=Count(Something)

example

Grouping:

load * inline[

Compliance,ComplianceGroup

Compl,Compl

NonCompl,NonCompl

Compl,Compl+NonCompl

NonCompl,Compl+NonCompl

];

[abc_18]

Hi Vineeth,

For single compliance value, numbers are populating correctly like for 'A' and 'D' but for values where I am doing addition (grouping) it's  not working. My measures is automatically aggregating only for single values but for group values it's just coming as unassigned data like '-' and there can see the remaining count.

[vinieme12]

Can you post some screenshots of Your data model  that shows association with the Inline table created for grouping

Also post all values in your compliance field and your script as to how you've grouped them in the Inline table

If your grouped values are not associated correctly that would only mean the values don't match in both the tables 

For example a value "a" is not same as "A"

Th values must match exactly including spaces 

[abc_18]

Hi Vineeth,

Yes, you are correct, there is data issue that's why the association isn't working.

I looked through the data model and saw that we are giving new names to the values we are adding up, as shown by the bolded text, so that the new names can be seen in the bar chart.

Below is the sample of Script from my app

Grouping:

load * inline[

Compliance,ComplianceGroup

NonCompl for XYZ,Not approved to have XYZ+Have latest version of XYZ
NonCompl for ABC,Machine to have data+Have latest version of ABC
Machine to have data , Machine to have data
Machine to have running , Machine to have running

]; 

And in Compliance column values are as below:

Compliance

Not approved to have XYZ

Have latest version of XYZ

Machine to have data

Have latest version of ABC

Machine to have running

For values 'Machine to have data' and 'Machine to have running' association are working because they are linked but this not in the case where we are adding values.

Can you please suggest what can I change to make this work?