Custom quarters using derived property

  • 15 September 2022
  • 1 reply

I need to create a derived property that functions as a quarter (Q1, Q2, Q3, Q4). Instead of January 1st through March 31st being Q1, I want it to be something like January 15th through April 8th is Q1. I could make that happen with an IF statement but I am having trouble in finding the right property to feed to the function that could process this calculation.

The best I have found so far is the server upload time property, but I can’t seem to figure out the date format of that property in the analysis tool to be able to correctly calculate what I need. Do you know the format of it or a better way in which I could achieve the above?



Best answer by rafaelduperron 15 September 2022, 18:56

View original

1 reply

I got some help from Amplitude support and learned that the server upload time property gets passed to the reporting environment in a unix long timestamp format. i.e. 2020-10-16 = 1602831600000