Any way to display selected records in formatted text using QuickSight?

So what I want to get here is like:

Recent 3 records by record time are:
- <record-a> with <info-a> at 2023-08-03 20:00:00
- <record-b> with <info-b> at 2023-08-02 20:00:00
- <record-c> with <info-c> at 2023-08-01 20:00:00

with a table structure

recordID recordTime recordInfo
record-a 2023-08-03 20:00:00 info-a
record-b 2023-08-02 20:00:00 info-b
record-c 2023-08-01 20:00:00 info-c

This is close to the example given by top ranked computation, but I basically 1) want to use recordTime column (with type date) as the ranking factor directly without any aggregation, but cannot find a way to prevent the recordTime from aggregating in the value field well of that insight; 2) want to insert the recordInfo field’s value directly into the narrative record, but am not sure how to write the code in the narrative editor, when only computations, parameters and functions are shown in the right side bar.

After all, I guess I’m asking: can I display just lines of records that’s formatted properly instead of aggregated values with QuickSight insight?

If not, is there any other feature I can use to display selected records in formatted text (i.e. that line “ with at 2023-08-03 20:00:00”) in QuickSight? I don’t want it shown as a table so table may not work for me.

Anyone have some ideas? Thanks!

Hi @BowandHelm

Can you try below steps and let me know if this works for your use case.

  1. Create a calculated field to concatenate record, info and time.
    example : concat(Product,’ with ‘,toString(Sales),’ at ',toString({Order Date}))

  2. Create a table visual with concat string calculated field

  3. Sort the field using timestamp field.

  4. Add filter to display top 3 by timestamp. In my example, i am using Sales as measure to pick top 3

  5. Remove the table borders for cells and headers using format visuals.
    Final visual will be displayed as shown in the image below.

2 Likes

Yes it works! Thanks Ashok!