topic Re: Single Measure Alert in Activator

Single Measure Alert

Anonymous — Fri, 22 Mar 2024 18:00:25 GMT

I think its misconfigured this alert, could someone help me solve this please?

In my PBI report I've create a measure which is just a percentage, then I show that measure in a Card (its the only thing i need to show a single number), after that i've set an alert in Reflex, but instead of getting the data as a property it seems like its asigned as a column Key

So I dont want that many IDs each time we refresh the dataset (1H), we have 25 wich is wrong

In that case i only want one ID 'Average Measure' and that numbers should be the property
Any suggestions to solve this?

Re: Single Measure Alert

Anonymous — Mon, 25 Mar 2024 01:23:04 GMT

Hi Anonymous ,

I did some testing and this is my test data:

I create some measures and put them both into the table visual and the card visual:

If I create the alert from card visual, it only has one ID:

But if I create the alert from table visual, it has several IDs:

So please try to create alerts from Card visual directly.
If there are still questions, please continue to contact me.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Single Measure Alert

Anonymous — Mon, 25 Mar 2024 16:27:54 GMT

Thanks it works, why this happened?

Re: Single Measure Alert

Anonymous — Tue, 26 Mar 2024 00:42:13 GMT

Hi Anonymous ,

My understanding is that because when you put a measure in a card visual, the measure does not apply filtering because the card visual contains only one value and no other dimensions. But when you put the measure in table visual or other visual objects with multiple dimensions (e.g. visual objects with x-axis), the measure automatically applies filtering.

Best Regards,
Dino Tao

Re: Single Measure Alert

jameshutton — Tue, 26 Mar 2024 13:00:09 GMT

Anonymous , just to add to the replies you've already had: if you create an alert on a table, then the alert will apply to each row in the table. For example, suppose you have the table below, showing sales per region. Suppose you set an alert on this table: "alert if sales become greater than $4m". Then you will get an alert if sales for any region become greater than $4m. I've shown below a simple sequence that would generate an an alert for the "West" region.

Yesterday: sales for all regions are less than $4m -- no alert generated

Region	Sales
South	$1m
North	$2m
East	$3m
West	$3.8m

Today: sales for "West" region become greater than $4m -- Data Activator alerts you for the "West" region

Region	Sales
South	$1m
North	$2m
East	$3m
West	$4.1m