8 Replies Latest reply on Dec 13, 2016 6:13 PM by Sujay Paranjpe

# Calculated field -  value of dimension2 based on number of records for each Dimension1

Hi there, I am trying to create a calculated fields to give me the value of Keyphrase Owner (ie domain1 or domain2) with the greatest number of records for each value of dimension Keyword List

Im really struggling with this, but im sure it can be done. Any help is appreciated.

Cheers

James

• ###### 1. Re: Calculated field -  value of dimension2 based on number of records for each Dimension1

Hi James,

I have the solution. Can you send me the .twbx file. I will edit the file and send it back to you.

Sorry mate, difficult to write down the steps here.

Best,

Sujay

• ###### 2. Re: Calculated field -  value of dimension2 based on number of records for each Dimension1

Sujay, thanks so much for the quick response.

Here is the workbook

Cheers

James

• ###### 3. Re: Calculated field -  value of dimension2 based on number of records for each Dimension1

Hi James,

Cant see the workbook.

Best,

Sujay

• ###### 4. Re: Calculated field -  value of dimension2 based on number of records for each Dimension1

Hi James,

The twbx has a direct connection to the Google Spreadsheet I believe. I do not know the credentials obviously. Can you generate the extract and share that .twbx?

Best,
Sujay

• ###### 5. Re: Calculated field -  value of dimension2 based on number of records for each Dimension1

Hi Sujay

Cheers

James

1 of 1 people found this helpful
• ###### 6. Re: Calculated field -  value of dimension2 based on number of records for each Dimension1

Hey James,

I have attached the .twbx.

I have created a calculated field - rank. It uses INDEX table calculation. INDEX ranks the records based on certain measure.

I would leave it to you to understand the logic rather than me explaining it step by step. If you still need any help, I will be able to explain.

Best,

Sujay

1 of 1 people found this helpful
• ###### 7. Re: Calculated field -  value of dimension2 based on number of records for each Dimension1

Thanks Sujay

Thats fantastic. Exactly what I was after. I still need to get my head around table calculations properly to fully appreciate the logic, but this certainly has helped me along.

Cheers

James

• ###### 8. Re: Calculated field -  value of dimension2 based on number of records for each Dimension1

Hi James,

You are welcome.

If my solution has resolved your query, please select 'This Helped Me' link ans well as mark the answer as correct.This way question will disappear from unanswered questions list from forum

Best,

Sujay