How update expression to always select Last 2 days data

[vidhyancs]

Basically i need a chart only to show last 2 days analysis. Attached sample qvf and data

TIA

[agigliotti]

Hi @vidhyancs ,

you could use the below set analysis expression:

=Count( {< Date = {">=$(=Max(Date,2))<=$(=Max(Date))"} >} account)

I hope it can helps.

Best Regards
Andrea