How to Highlight cell in Table Chart for Min of Job Start Date & Max of Job End Date

[Biswajit_1993]

Hi Team Can you help me to format my table chat where I want to show the Min of Job Start Date & Max of Job End Date as highlighted column.

Please find below my visuals.

Here the Yellow highlighted cell is Min of Job Start Date & Max of Job start Date.
I want the same things in QuickSight please help if you have any idea.

[Max]

You can make a calculated field that checks if it is the max or min and then highlight when it is.

Here is the calculated field.

isMax= ifelse(maxOver(({queue_EnqueueTimestamp}),,PRE_AGG)={queue_EnqueueTimestamp},‘Highlight’,‘Do Not’)

Then you can use that field to highlight.

[Biswajit_1993]

Hi @Max Thanx for your solutions.