Best Of

Hi, @John-Peddle,

This should be possible using a method more or less the same as I discussed here: https://dojo.domo.com/t5/Card-Building/hello-how-to-compare-month-to-month-with-secondary-axis-in-card/m-p/38214/highlight/false#M5099

For a table card, you need to have a data column for each column to be included in the table. If your dataset already has all the columns you need, then you're all set. However, in your case, seems you don't have all the columns you need in the dataset. Enter the Beast Mode calculation.

You'll need to create a Beast Mode calculation for Month/Year, Discrepancies, and %Difference for each of the four months. That's a total of 12 Beast Mode calculations. The good news is that they'll be nearly the same with just small differences to account for the varying number of months prior.

For example, for the Month/Year calculation for the current month, your calculation will be something like this: 

min(
  case 
    when month(`Date`) = month(CURRENT_DATE()) then concat(year(`Date`),'-',month(`Date`)
  end
)

 The corresponding calculation for the prior month will look something like this:

min(
  case 
    when month(date_add(`Date`,interval 1 month)) = month(CURRENT_DATE()) then concat(year(`Date`),'-',month(`Date`)
  end
)

 and so on for prior months, changing "interval X month" to the appropriate number of months prior to the current month.

The other columns will have very similar logic, but instead of min(), you'll want to use sum() or count() depending on your data structure. Also, for the %Difference, you'll be doing additional math: sum(current month discrepancies) / sum(prior month discrepancies)

Hope that gets you going.

~Dan