Data driven alerts for measures not shown in view

Hi All,

I have a dataset which has the measures 

            1. Serial Nrs - (Countd(Serial Nrs)) 

            2. Serial hrs when Submitted - (COUNTD(IF [Submit/ not submit] = 'Submit' then [Serial Number] end )

I am representing it as a dual axis chart in my view (Sheet 1 in my example). 

The task is to create a Data Alert, after publishing the dashbaord to server, whenever the difference between the above two measures is more than 50% at the level of granularity of Country (Sheet 2 in my example). 

So in the example my view (Sheet 1 ) does not have the difference more than 50% between the two bars(since it is not at the level of country and is aggregated for all countries) , however the difference of the two measures for Canada on the same day has a difference more than 50% ( 32 and 3). 

To my understanding Data driven alerts need a numeric axis of a chart, and I am not showing the view which results in the data alert (Sheet 2).

Is there a way to have the data alert set up without showing the measure / view . My current view (Sheet 1) is at a higher level of granularity as that of Sheet 2 (which includes the country field as well) .

Thank you, any suggestion would be helpful.

Regards,

Rishi Saka