Member-only story
Calculate Remaining Days of a Month in Data Studio
It’s not as straight forward as it sounds!
Introduction
Have you ever been in a situation where you create a Data Studio report and there are a lot of obstacles to get through?
Well, something like that happened to me last week. I was working on a dashboard automation with different data sources, calculated fields, blends and so on, when suddenly I realize I needed a very specific metric.
What was it?
I wanted to calculate the average daily budget available, until the end of the month. But there is no field providing the remaining days of the month, in Data Studio. As a pure 90’s kid, I started with a Google Search. After a few searches and blog post reads, I realized there is no working solution that will cover my needs. Most of the solutions proposed to create a Google Sheet, then calculate the remaining days of the month, then connect it with my Data Studio dashboard, blah blah.
Not good enough! As I was saying, I was working for an automation task. So, I started working on my own solution.
It is not fancy, but it’s working…
