How to exclude weekends from the data

[deeavhad]

How to exclude weekends from the data to display only weekdays data in a chart

[abhijitnalekar]

Hi @deeavhad, 

if(WeekDay(DepartDate)>3,'WeekEnd','WeekDay') as week

Create the above new field in the script. And you can filter the data accordingly.