How to display report generated time in quicksight.
i wrote a measure as now() and now if i pull the value to card its taking count and not displaying datetime. How to solve this?
P.S Iam not using Paginated report
Hi @Slytherin
I generally use the Insight visual for this. Add the calculated field to the TIME dimension.
Customize the narrative by
a. Adding a Maxmimum value for the added calculated field
Something like this
b. Use the formatted value of the Max computation into your custom narrative text area
c. Your narrative should look like this
d. In the visual change the aggregation to minute so you can have the date and time portion to show and you can format the time to be shown in your desired format
1 Like
Hi Slytherin,
For your requirement, instead of creating the now() function in the analysis, you can create it at the dataset level and use the Pivot visual instead of the KPI card. Then, you can rearrange the visual as per your requirements.
Yes, as suggested by @Giridhar.Prabhu, you can also try using the Customize Narrative feature.
Thanks & Regards,
Biswajit Dash