Filled Gauge Chart Built off Results of Another Card
I'm trying to figure out how I can best make a filled gauge card based off the results of another card (not even sure that is possible). The basic idea is that I'm counting the number of unique dates every month associated with each individual user. So, for example, in July, User A has 3 unique dates associated with them, User B has 2, User C has 2, User D has 1, etc. That's the first card. The filled gauge card I want to show a total of how many of those users have passed a certain threshold. So if a user has 2 or more unique dates associated with them, then the gauge goes up by 1, essentially showing how many of the total users have met the monthly threshold. If I can't build a card off of another card, what might be the best way to do this, in general? Thanks!