I want to create a card that provides an average monthly overview
So, we have a dataset which runs once per day and captures user log in data. It captures the latest log in count number for each user for the last week, 30 days and all time, so that we can keep track of how frequently the system is being used. I could then, for example, on the card see that on X date, we had 54% of users active within the last week, 75% active within the last month, and 99% active all time.
However, I need to create a separate card that shows an average, so that I could, for example, see what the average stats were for the previous month so that I could compare it with stats for the current month. Any ideas on how I could accomplish this?