Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Best way to get the [Country] field to be a report header? (see screenshot)

Carluccio555
9 - Comet

Im making progress with reporting conventions! How do I turn that [Country] field into a header for each record?

 

thanks!

 

Carluccio555_0-1668827081855.png

 

3 REPLIES 3
DataNath
17 - Castor

Hey @Carluccio555, you could do something like this...

 

First step is to create your Table. Group by country and then just untick the [Country] field as that'll be present in the header:

 

DataNath_0-1668849104886.png

 

Next, use a Report Text tool to add text to the Table - here I've just selected to place it above and within the body text we can then reference the [Country] field:

 

DataNath_1-1668849160494.png

 

From this, we get the following output:

 

DataNath_2-1668849176242.png

 

Just a quick note for future reference: Attaching an actual data sample alongside pictures/explanations is always super handy as we have to rebuild screenshots by hand! Hope this helps!

Carluccio555
9 - Comet

thanks and what is the best way to also add a timestamp to the report text for the time when the workflow was run?

DataNath
17 - Castor

Hey @Carluccio555, before the report text, just add a Formula tool and use it to make a new column. Use the DateTimeToday() function, which returns today’s date/time (set the data type of the field to date if you only want the date part, or wrap it in ToDate()), and then you can reference this newly created date field in the report text tool.

 

DataNath_0-1668903305688.png

DataNath_1-1668903316293.pngDataNath_2-1668903325735.png

Labels