unable to exclude null in date field

[#1]

Hi Folks,

I attached the sample data and required output.

when i load the excel sheet data i got the null values..How to exclude the null values..?

In x-axis i want to show only latest 12 weeks data that should be like ww1,ww2,ww3,.....ww12. How to take it in week format as given..

Open & Close - Excluding Null Values

How to show "Open" Values in Left and "Close" Values in Right..

Thanks in advance..

Regards,

Venal

[Gysbert_Wassenaar]

Please don't clutter this site with duplicate discussions: unable to exclude null in date field‌

I also don't understand what you're asking. Can you give more details?