Average with Set analysis

[brunolelli87]

Hello guys, 
I'm trying to create a chart with Date as Dimension and the following expression:

=avg({1 <STCK={'CVCB3'}, DVPG={'> 03/01/2020'}>} VDAF)

I don't know why but it's not working, it shows NO DATA TO DISPLAY,  but I'm sure there are available data to display. 

My intention is to create a chart where Date (DVPG) is a dimension, and the expression is the average of VDAF values, from 03/01/2020 up to today!

How can I do it?

Thanks

[Saravanan_Desingh · Accepted solution]

One more to try:

=avg({1 <STCK={'CVCB3'}, DVPG={">$(=Date(Addmonths(Today(), -3)))"}>} VDAF)

[Saravanan_Desingh]

=avg({1 <STCK={'CVCB3'}, DVPG={"$(='>'&Date(Addmonths(Today(), -3),'MMDDYYYY'))"}>} VDAF)

[brunolelli87]

Thanks for all your assistance.

This one is working perfectly!

[Saravanan_Desingh]

you welcome