Removing Weekends from data/Line graph

[GeorgeEard]

I have currently got the dimension "=if([Creation Date] > '01.06.2024',[Creation Date],null())" in my line graph however it includes weekends.

How would I be able to exclude weekends from the line graph?

[Kushal_Chawda]

@GeorgeEard  It's better to create Flag in script but you can try below

if([Creation Date] > '01.06.2024' and not match(weekday([Creation Date]),'Sat','Sun'),[Creation Date],null())