{"id":"0160246e-b0a5-4ae9-913e-1cee9e1307c3","createdAt":"2024-10-02T07:24:46.819Z","updatedAt":"2024-10-02T07:50:22.513Z","isDeleted":false,"version":54,"date":"2024-10-02T07:24:46.819Z","published":true,"title":"Median Functions","notes":{"type":"doc","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"As part of our continuous efforts to extend the functions library in Francis, we've now added support for medians. Similar to the existing sum and average functions, the median functions are released with three additional variants:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"median_last_year()","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"median_ytd()","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"median_last()","type":"text"}]}]}]},{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"text":"To learn more about the newly released median functions, visit our ","type":"text"},{"text":"documentation","type":"text","marks":[{"type":"link","attrs":{"rel":"noopener noreferrer nofollow","href":"https://docs.francis.app/guides/documentation/modeling/functions","class":null,"target":"_blank"}}]},{"text":".","type":"text"}]}]},"archived":false,"imageUrl":"https://uploads.productlane.com/32c65d311af42bea54654220d9b184d8.png","projectId":null,"workspaceId":"e7c97f92-84aa-4319-86f8-6c1043c22054","html":"

As part of our continuous efforts to extend the functions library in Francis, we've now added support for medians. Similar to the existing sum and average functions, the median functions are released with three additional variants:

median_last_year()
median_ytd()
median_last()

To learn more about the newly released median functions, visit our documentation.

Francis changelog

Median Functions