Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RESUELTAS

Adding percentage sign to rows in Table tool

MattR79
Asteroide

I have a table, set up like the chart below and I need to add a % to only the bottom two rows of the table, I thought there would be a way to write a formula in the row rules however I cannot seem to figure it out.  So, to restate, I only want to add the % to the % of Aged Breaks total rows at the bottom but no other rows and only the numeric columns.

 

 Description1-34-67-910+TotalDay Over Day

User 1

Current Day302050
 Previous Day302050
User 2Current Day3019121
 Previous Day3017110
User 3Current Day000000
 Previous Day000000
TotalCurrent Day6039180
 Previous Day6037162
% of Aged BreaksCurrent Day540540100 
 Previous Day3701747100 

 

4 RESPUESTAS 4
AndrewDMerrill
Púlsar

I could be wrong, but I do not believe that you can edit the data like that in the Table Tool. What format is your data in before going through the Table Tool, because that would be quite simple too achieve with a Multi-Row tool and Multi-Field tool before being sent to the Table Tool.

MattR79
Asteroide

It's coming out of a formula tool just prior to the table tool, if there is another way to handle it other than in a table, then I welcome that option as well.  I am not locked into doing it any particular way.

AndrewDMerrill
Púlsar

Here is an example for you that should do what you're looking for:

Screenshot.png

MattR79
Asteroide

That did exactly what I needed it to do, thank you.

Etiquetas