How do you render a long string (>2,047 characters) in a visualization?
Currently, the string is clipped after 2,047 characters and I cannot view the whole text.
Hi,
Thank you for reaching out. String are currently limited to this size. What you will need to do is split the string into segments prior to loading into QuickSight and use multiple fields so that the string is not truncated in the display. We’ll definitely look at supporting longer string lengths in the future.
Best,
Sean
Can the multiple fields be concatenated to render as a single display field?
Our team uses Quicksight to troubleshoot customer issues. And it’s very difficult for them to stitch the data together.
Hi @rishis -
You can do this with the Concat - Amazon QuickSight function.
A tip for the word wrapping, create a calculated field with a placeholder of “temp”, add to visual and set the height/width of the cell, then add the concat function to the calculated field.
Example:
@robdhondt thanks for your reply. Your suggestion seems to work well where the dataset is a file (e.g. CSV) and I was able to reproduce it. However, it doesn’t seem to work for when the dataset is PostgreSQL (without SPICE) – the text in the visual is clipped after 2,047 characters even though the length of the concat calculated field is greater. See screenshot (sorry I can’t share a full screenshot because it’s sensitive data).
Hi @rishis -
You’re right the visual limitation is dependent on the data source. I was able to reproduce what you are experiencing. It’s great you are bringing up this use case here.
Here’s a workaround, that may work for your use case.
Step 1 - Use the Replace - Amazon QuickSight function to create calculated fields for your split text blurb columns.
Step 2 - Create an Insight and add your split fields as categories.
Step 3 - Custom narrative and add 2 “bottom ranked” computations. Note: I changed the index to [0] because I will always be showing 1 record at a time.
Step 4 - Customize computation blocks formatting.
Step 5 - Add a filter action to allow your users to see the text blob for each record.
Hi @robdhondt - good to know it is a known limitation. I have experimented with using Insight, however, the trouble is only a maximum of 5 “categories” are being assigned. And in some cases, the text is more than 5 * 2047 in length.
@rishis -
That is an incredible amount of text to render in a dashboard. You could try using multiple Insights, but it sounds like you’ve experimented with that.
It sounds like you may have a hard requirement to keep this entirely within QuickSight. If you don’t I would consider truncating the text field (less than 2047 characters) and then providing a hyperlink to the full text. IMO - this also makes for a better user experience.
@robdhondt - it is a lot of text. The use-case is for our support team to troubleshoot api network activity which has large payloads. In addition to Quicksight being our business intelligence tool, it serves as a troubleshooting tool that keeps data within the AWS ecosystem.
@rishis
Thank you sharing your detailed requirements and feedback. I will submit this as a feature request. Please share your company name along with your email id with me privately.
Thank you,
Deepak
Hi, @rishis. Did the responses from @robdhondt and @DeepakS answer your question? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!
Hi @robdhondt . Can you please elaborate a bit on this? I am currently trying to display a large set of characters and my dataset is a CSV File. I am new to Quicksight and I am not able to duplicate your results. Any insight will be helpful.
Thanks