MySQL Calculated Field
I'm trying to create a table using MySQL as a datasource. The database is updated monthly with new information that is appended to the end of the database. Each row in the database has several columns of data and a column for a timestamp from when it was created/added. I would like to create a calculated field that is the previous month's number so that I can see the same dimension across multiple months. What I would like to do is create something like this. I'm trying to figure out a calculated field formula for the first 3 Metrics. Open to suggestions of other ways to solve this general issue.