Scheduling alerts for weekends/weekdays

[duncan_anderson]

Hi Looker Community - How could I go about creating a dimension that take sum of amount on weekday orders only, and one for weekends only?

Thanks,

[minerkt]

Hi @duncan_anderson ,

Are you trying to create a new dimension in the view file or just on a report with the “custom dimension” ?

If you are writing to the view file, you could write some case statements in the SQL parameter to achieve this.  With the “custom dimension” option, you could write some if statements and add your logic in there.

[duncan_anderson]

Hey there - I managed to solve this by using the day of week index for the existing date dimension. Thanks anyways for the response!