Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May be this?
Create Line Chart
Dimension as DateField
And Expression should be this? If you want label you can give label as GDPRange
Sum({< DateField = {'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} >} GDPValue)
And, Back ground expression may be this
If(GDPRange, Red(), Green())
Or
If(Sum({< DateField = {'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} >} GDPValue), Red(), Green())
Hi,
Thanks for reply. I tried to replicate, But its not working. I am adding here my example file.
What I want are:-
1) Based on input dates, GDP should not change
2) Based on input dates, online highlights the GDP with different color.
E.g, if I input dates only those parts change to some other color, but at the same time line chart remain plotted for complete year. Please look into image. Once again, Thanks in advance