hello , how to compare month to month with secondary axis in card visualization?

Hi, user04753,

If I understand your question correctly, you want a card that has a month-over-month comparison of two sets of metrics (count; avg interactions) that will appear on two different y axis scales, broken out by Type on the x axis. Is that correct?

I think you can do this using a Beast Mode. Check out this Knowledgebase article that explains some general concepts and give examples: http://knowledge.domo.com?cid=beastmodecomparison

Since you effectively want to include current and prior month count and average number of interactions (a total of 4 metrics), you'll need to create each of those metrics as a separate beast mode. That's because of the way the "Line + Grouped Bar" chart works.

The logic in these beast modes is to count or average the interactions if the month of the date is the same as the month of the current date (current month) or if the month of date + 1 month is the same as the month of the current date (prior month).

The four beast modes:

1) Current Month Count:

count(
  case 
    when month(`Date`) = month(CURRENT_DATE()) then `Type`
  end
)

2) Prior Month Count:

count(
  case 
    when month(date_add(`Date`,interval 1 month)) = month(CURRENT_DATE()) then `Type`
  end
)

3) Current Month Interactions:

avg(
  case 
    when month(`Date`) = month(CURRENT_DATE()) then `Number of Interactions`
  end
)

4) Prior Month Interactions:

avg(
  case 
    when month(date_add(`Date`,interval 1 month)) = month(CURRENT_DATE()) then `Number of Interactions`
  end
)

Create the visualization:

To create the visualization, you'll put "Type" on the X axis, then add "Prior Month Count" as the Y axis, followed by "Current Month Count", "Prior Month Interactions", and "Current Month Interactions" as series.

By default, this chart will plot the field in the Y axis as a line and will plot each of the three series as bars. You can change that defualt behavior by changing this parameter: Chart Properties --> General --> Series on Left Scale. By entering the value 2, you're telling Domo to plot the first two fields as lines and all remaining fields as bars.

Your chart will look something like this: