Alert for goal doesn't appear when having two columns in summarize

Get Help
1

When having two columns in the summarize section, even when i set a goal, when creating the alert the option for above or below the goal isn’t showing up anymore

image
image2346×864 83.4 KB

image
image750×418 16.3 KB

Am i doing something wrong or is this a limitation of the alerting system, when i remove one of those summarize the option returns.
The behavior i expect is for the goal to be affected to one of those columns at least

2

Hi @lmouad ,

This is a Metabase limitation. Goal alerts aren't supported when the chart shows more than one series. To set a goal alert, plot only one of your columns, distinctcount or Count (tested on v0.65.3.7):

goal-alert-workaround
goal-alert-workaround1360×1579 152 KB

  1. Open your question and click "Visualize", then the gear icon next to "Visualization" at the bottom left.
  2. In the "Data" tab, under "Y-axis", remove the column the goal doesn't apply to (e.g. distinctcount), so only Count is plotted.
  3. In the "Display" tab, check that "Goal line" is on with your value.
  4. Save the question.
  5. Open the alert again. "When results go above the goal" and "When results go below the goal" will now be available.

If you need a goal alert on both distinctcount and Count, duplicate the question (••• > "Duplicate") and plot distinctcount in the copy, with its own goal line and alert.

Best,
Deekshith