i am trying to put a kpi component on top of a dashboard to let the user know what date/time the latest record was created at. i have a field in my data set ‘created_at’, i converted it from dimension to measure, dropped into a kpi component hoping to change the aggregation to ‘max’, but to my dismay the only aggregation options are ‘count’ and ‘count distinct’.
which i believe suggests creating a calculated field with the date values converted to text, but couldn’t make head or tails of it. i tried creating a calculated field with the max value, i tried putting that or the string-converted date field into an insight and into a kpi component, but it wouldn’t show the max value, only a count or count distinct.
what am i missing? how do you clever people display the min/max of a date field in quicksight?
Considering your use case I may not opt to set up a KPI visual, instead I would go for the second option you mentioned, a narrative and add the date field in the time field well and add computation to fetch period over period computation. Then add current date metric from computation to show the max of date field.
Attaching few snippets from a sample implementation: configuring computation
Did this solution work for you? 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!
