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

I have a column with monthly data: 1/04/ 23,1/05/23 etc, which I'm trying to plot together with some daily data. Is there a e a way to create a calculated column that will take the monthly value and assign that value to each day of the month?


Anthony Giambalvo

Recommended Posts

Thanks Kirsten, this way very close to what I was looking for, but it did the sum over every December for example.

I decided to use my daily resolution data table, import my monthly data as additional columns, plotting these as a line chart worked.

It seems like if your starting point in the database is from a higher resolution i.e. daily it will work, but not visa versa.

Thanks for the quick reply and for getting me thinking.

Cheers,

Anthony

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...