Report Which Displays Text With Concatenated Column

Frank Caruso shared this question 19 days ago
Answered

I have been tasked with creating a report that looks like this:

ce212847eca2d02cf2bafade1364d4b6

Using a single report with append queries I can get all of the counts/values. But what I cannot figure out is how to concatenate those results with a text description. Not sure if this is even possible. Any help is appreciated.

Comments (2)

photo
2

Hi Frank,


Thanks for your question.


Do the text values need to be concatenated, or are they to be their own separate column? If they can be in their own column it's a fairly easy process, where you are able to create a Calculated Field with text input, and add the calculated fields to each of the subqueries. You can then also make the value column a Drill Down/ Through, which is what it looks like you are aiming for in your initial image.

Another simpler option is to add in the columns as rows instead so that every field is listed vertical rather than horizontally.

Finally, you could use a Report canvas, and create more of a Dashboard style report, where each metric is a Numerical Display Chart and you drag text widgets with the name of each metric you are measuring into the canvas.

I've attached a couple of screenshots as reference, let me know if any of these meet your requirements.

Kind regards,

Simon


/b75d0ebc805930d169b79070f7fe54c3


/0eddf9bb0a773f4a011df1877efb442c


/168c048389c1193227c088355d8acf5e

photo
1

Arg!! Hate when I miss the obvious solution. Presenting the data as Rows is the solution.

Thank you Simon