Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
One more to try:
=avg({1 <STCK={'CVCB3'}, DVPG={">$(=Date(Addmonths(Today(), -3)))"}>} VDAF)
=avg({1 <STCK={'CVCB3'}, DVPG={"$(='>'&Date(Addmonths(Today(), -3),'MMDDYYYY'))"}>} VDAF)
Thanks for all your assistance.
This one is working perfectly!
you welcome