I have two fields one is date and the other is sales.I would like to create a line chart with date as dimension but only dates from Jan 2021 -March 2021 and from these months ,I want to show sales values every two week like Jan01,Jan15,Feb01,Feb15 etc. My date is a time stamp .How can I make a line chart using set analysis and without changing my timestamp to date(maybe using date.autoCalender.Date)
