
1. Re: Adding together separate Ranks from a Table Calculation
Matt Lutton Jun 21, 2016 6:47 AM (in response to Sam SuttonReid)Yes, nearly anything is possible  can you post a sample TWBX (packaged workbook) using Superstore Sales or a similar sample dataset, along with a mockup of your desired results/output? This will help you ensure you get the best possible help from volunteers on this community forum. Cheers!

2. Re: Adding together separate Ranks from a Table Calculation
Sam SuttonReid Jun 21, 2016 7:12 AM (in response to Matt Lutton)Here you go.
I essentially want to add the 3 x ranked columns together to get a total.

Ranking Query.twbx 1.2 MB


3. Re: Adding together separate Ranks from a Table Calculation
Matt Lutton Jun 21, 2016 8:05 AM (in response to Sam SuttonReid)I'm not sure I completely understand  are you just trying to show a "4" value for each Rank total? Knowing your expected results would help me understand  mockups are great!
Can you also explain why you want to see that summation of ranks  what purpose does that serve?

4. Re: Adding together separate Ranks from a Table Calculation
Matt Lutton Jun 21, 2016 8:11 AM (in response to Matt Lutton)Also, I highly recommend this video on Table Calcs  you're going to need to apply a Table Calculation on top of the existing measures, which means you'll need to give those measures names, etc. In other words, there are several steps you'd need to take to get a Total of 4 for those Rank measures  my solution would include using a separate worksheet for the grand total row, but I'm not going to do that if it will not meet your needs.
The specified item was not found.  See the video "Setting up for Table Calculation Success"
Cheers and good luck!

5. Re: Adding together separate Ranks from a Table Calculation
Matt Lutton Jun 21, 2016 8:12 AM (in response to Sam SuttonReid)More recommended reading on how Totals work inside Tableau (3 part series  VERY educational, and from the same author as the "Setting up for Table Calc Success" Think Data Thursday video mentioned above.

6. Re: Adding together separate Ranks from a Table Calculation
Luciano Vasconcelos Jun 21, 2016 8:24 AM (in response to Sam SuttonReid)I unified its ranking by adding any ranking and creted a new classification from the lowest to highest

Ranking Query.twbx 1.2 MB


7. Re: Adding together separate Ranks from a Table Calculation
Patrick A Van Der Hyde Jun 21, 2016 4:17 PM (in response to Matt Lutton)Just saying  how nice to see you Matt Lutton.

8. Re: Adding together separate Ranks from a Table Calculation
Sam SuttonReid Jun 21, 2016 11:54 PM (in response to Matt Lutton)Hi Matt,
It would be a value of 4. So for example if Furniture is 3rd in profit, 2nd in sales and 2nd in quantity then Furniture would have a score of 7 (3+2+2). We use it at my work for rankings Tables for KPIs.
I'll check out the videos as well.
Thanks very much for you help.
Sam

9. Re: Adding together separate Ranks from a Table Calculation
Sam SuttonReid Jun 21, 2016 11:54 PM (in response to Luciano Vasconcelos)Luciano  Thanks for this, unfortunately I'm getting an error message on this end saying Tableau can't load the file.

10. Re: Adding together separate Ranks from a Table Calculation
Luciano Vasconcelos Jun 22, 2016 4:19 AM (in response to Sam SuttonReid)Try to update your version to 9.3
Enviado do meu iPhone
Em 22 de jun de 2016, às 03:55, Sam SuttonReid <tableaucommunity@tableau.com> escreveu:
Tableau Support Community
Adding together separate Ranks from a Table Calculation
resposta de Sam SuttonReid em Forums  Visualize a discussão completa
Luciano  Thanks for this, unfortunately I'm getting an error message on this end saying Tableau can't load the file.
Responda a esta mensagem respondendo a este email ou vá para a mensagem em Tableau Support Community
Inicie uma nova discussão em Forums por email ou em Tableau Support Community
Seguindo Adding together separate Ranks from a Table Calculation nestes fluxos: Caixa de Entrada
Este email foi enviado por Tableau Support Community porque você é um usuário registrado. Você pode cancelar a assinatura da Tableau Support Community agora mesmo ou ajustar a frequência de email nas preferências do seu email

11. Re: Adding together separate Ranks from a Table Calculation
Luciano Vasconcelos Jun 22, 2016 4:44 AM (in response to Sam SuttonReid)Here is the app in 9.2.4 version.

Ranking Query v 9.2.4.twbx 1.2 MB


12. Re: Adding together separate Ranks from a Table Calculation
Christina Gremore Jun 22, 2016 12:46 PM (in response to Sam SuttonReid)Hi Sam,
Here's what you'll need to do.
1. "Materialize" the table calculations you use to find the rank. By "materialize", I mean save them as part of the data source. To do that, just grab your table calc pill from the measure values card, Ctrl+click, then drag it into the data pane on the left. It'll pop in there and you can give it a name. Do this for all the ranking table calcs.
2. Create a new calculated field and just add them all together.
See attached workbook for example. (New calc field is "Rank Totals")
If this resolves your issue, please mark it as the correct answer. Thanks!

Ranking Query CG.twbx 1.2 MB


13. Re: Adding together separate Ranks from a Table Calculation
Matt Lutton Jun 22, 2016 1:40 PM (in response to Christina Gremore)Nice job, Christina  this is precisely what I was describing Sam  by adding the Table Calculations to your Data Pane, you can then use them in other calculations. I was thinking you'd need to use a Table Calc on top of the ranks, but it appears that you may just add them together.
Thanks for the example, Christina  I haven't had much time to devote to building out Forum solutions lately, but I still like to lend a hand where I can!

14. Re: Adding together separate Ranks from a Table Calculation
Christina Gremore Jun 22, 2016 2:20 PM (in response to Matt Lutton)Yeah, I was bracing for a fight, but it turned out to be as simple as I'd hoped! Luckily rowlevel calculations are pretty straightforward.