Alteryx Designer Desktop Discussions

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

Adding percentage sign to rows in Table tool

MattR79
8 - Asteroid

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 REPLIES 4
AndrewDMerrill
13 - Pulsar

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
8 - Asteroid

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
13 - Pulsar

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

Screenshot.png

MattR79
8 - Asteroid

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

Labels