cal

[smilingjohn]

HI All,

This are my expression  now i want to bring this as a dimension..

Can somoene please suggest my how to bring this expression into Calculted DImension ?

=Count({<Env={'AB'}>}if([Status z='Pass',0))

Count({<Env={'AB'}>}RunNumber)

count(Cost)

Thanks in Advance

[devarasu07]

Hi,

Try like this

=aggr(Count({<Env={'AB'}>}if([Status z='Pass',0)),RunNumber)

In general,

Aggr( <here write your calculated expression >), your dimension)

https://www.analyticsvidhya.com/blog/2014/02/aggr/

Thanks

Deva

[smilingjohn]

Thanks for the Reply Deva

This is showing different result ..

Is there any ither way to write the  calculted dimenion ?

Becuase the numbers are repeating ( Duplicating )

[devarasu07]

Hi,

It should work, can you share you app or screen shot? Tks

Regards,

Deva

[dinuwanbr]

Hi Roy,

Can you upload a sample here?

Rgds,

Tharindu

[smilingjohn]

Hi Devarsu,

Please find the attachment of the QVW file.

I have two charts first is the Expression based and second one is the Calculated Dimension.

I wante to remove the duplicates from Expression charts ..therefore tried to get that into Calculated dimension .

But this is not wrking..

Thanks

[smilingjohn]

Hi Tharindu..

I have uploaded the sample ..

I need to remove the duplicates ...which are repeating

Thanks

[dinuwanbr]

Dear John,

Basically What I found is your Data Model is wrong. Severity is in another table which is linked through Release Number and you are taking a count of RunNumber which is in another table. So obviously its duplicating. Try to do any applymap() or something to get necessary data from that table into second table.

Check the attached file here. Sheet no 2.

Rgds,

Tharindu

[smilingjohn]

Hi Tharindu ,

Can you please show me how do we Apply map ..

I have added the script

Please find the attachment

[dinuwanbr · Accepted solution]

Hi Roy,

Applymap has to be done in script level

Mapping_Severity:

mapping

Load

Rls,

Severity

from (The file for JIRA);

then while loading

ALM_TC_RUN:

load

...

...

Applymap('Mapping_Severity',Severity) as Severity

from (file for Alm_TC_RUN);

if u are loading JIRA file then comment severity field.

For More Please check followings

quick applymap example

Joins and Lookups

https://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Apply Map

Rgds,

Tharindu