How to aggregate time series data using pivot table (convert from daily to weekly to monthly)

[@mohammedalnour318]

Thanks for the wonderful presentation. I may ask how to covert any data to weekly data?

[@jassy4100]

but open and close data should be first value and last value in that series- for monthly first date and last date and for weekly first day and last day. If you can share how to adjust value field to arrive at that value it will be useful , otherwise it is not much help.

[@ButterflyKiss_0]

where is the weekly?

[@RESEARCHHUB]

here all data are in weekly level. notice the difference between the dates, for example, 11/19/2017, then 11/12/2017. So, the difference is 7 days between November 19 and 12!

[@jsmith772]

big up