Jump to content
We've recently updated our Privacy Statement, available here. ×

Binning by Week - want weekending date instead of integer


Caitlin Wrobel

Recommended Posts

Try this. First, instead of a Line Chart, set this up as a Scatter Plot, using the Line Connection option, ordered by your Date column, using the "First" aggregation method.

 

Next, create a new column in your data table with an expression like:

 

case DayOfWeek([YourDate]) when 0 then [YourDate] end

 

This will create a column that is populated with the week-ending date you specify, the rest of the fields will be blank. The DayOfWeek() function returns a number, from 0 (Sunday) to 6 (Saturday), so substitute the number that makes sense with your data.

 

Then for the Labels in your Scatter Plot, select this column, again using the "First" aggregation method, and you should just get labels for the dates calculated in the column.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...