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!
