Goals vs. Actual
Okay, so I'm trying to visualize two sets of information on one card. The first is our stored Goal, which is in one datasource being pulled into Domo. It's stored by Month and Year (two separate fields unfortunately, but I can work with that in ETL), and is a given number for the goal value - let's just say 100 for December 2017.
Then our actual traction towards that goal, is determined by a date field in a different dataset - so I need to count, based on whether that date's month and year match the goal's month and year. This could be say, 97 currently.
How would some of you approach this scenario, to show these values side by side...and filterable based on Goal Period?