Use card date filter values as variables in Beastmode calulations
We've been struggling with YoY comparison since we signed with Domo about two years ago. We quickly been able to do what we wanted with Beastmode calculations. We built some awesome charts like the one shown below where we compare the current and previous year, the budget for current year and the growth all on the same chart.
The limitation of using beastmode calculations is this limits the card to show only 2 years of data and makes the date filter useless, while for analysis purpose, the business absolutely needs to be able to play with the date filters to see Y-1 vs Y-2, Y-2 vs Y-3 etc. Right now, to fulfill this important need, we would have to duplicate the cards and obviously, create a complete new set of cards and beastmode calculations for each of previous years.
With the deployment of the new YoY function, we tought maybe we could have been able to replace beastmode calculations and play with date filters on top of the card, but unfortunately, we can't because the function is limited to one dimension only making this kind of graph impossible to build.
So the idea I watnt to suggest here to fix this is to be able to use the date filter values into Beastmode calculations as variable/function. I think this should not be so difficult to implement for Domo's developpers and would fix a bunch of issues like that.