how to show a single value in gauge

[NK]

Hello, 

How can I add yesterday's value in a gauge ?

For example, if its 6th of November, I want to show 0.67 in a gauge.

Thank you.

[Kashyap_R]

Hi

Change aggregation function according to your requirements

Sum({<[Date]={"$(=Date(max([Date])-1))"}>}Exp)

Hope this helps 

Thanks