Select menu column/measure options, what do they mean?

[EwoutVisionBI]

When editing my alert, the following part looks slightly different every time:

sometimes I have one selection to make, sometimes two or three. What do each of the selections mean, and what is the effect of it?

I'm asking because I made 7 similar alerts (based on almost identical visuals/just the measure is different), and some work as expected and others do not. My main issue is that not all high temperatures from the source data are recognized, usually only 80-90%.

Background: I'm looking at the maximum oven temperature for each oven that a batch is processed in. Every time the batch maximum temperature exceeds a threshold, the trigger should be activated.

[sajjad1122]

In data visualization and reporting tools, the "Select Menu" for column/measure options typically refers to a dropdown menu that allows users to choose which data fields or measures to display in a report or dashboard. Here's what these options usually mean:

1. Columns: This refers to the individual fields from your dataset, such as dimensions (like names, dates, or categories) that you can select to display on the report. Columns help define the structure of your data.

2. Measures: Measures are quantitative data fields (like sums, averages, or counts) that you can perform calculations on. They are usually numerical and are used for aggregating data to provide insights.

3. Filters: Some menus allow you to filter the data displayed based on specific criteria, helping you focus on relevant subsets of your data.

4. Sorting Options: These options let you choose how to arrange the data, whether ascending or descending, based on selected columns or measures.

5. Aggregation Methods: This might include options for how to aggregate measures (e.g., sum, average, maximum) to provide different perspectives on the data.

These options allow users to customize their reports and visualizations according to their specific analytical needs.

[v-junyant-msft]

Hi @EwoutVisionBI

 

Its main role is to create properties for the Reflex, for example, which property's value does the Reflex you create need to detect? And what are the conditions for the Reflex to be triggered?
You can refer to this document:
Create Data Activator triggers in design mode - Microsoft Fabric | Microsoft Learn


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.

[EwoutVisionBI]

Thank you Dino, but which is the property of the two/three? How can we know what each Select individually means?
I know about Detect, I'm only asking about the different dropdowns under Select part.

[v-junyant-msft · Accepted solution]

Hi @EwoutVisionBI ,

The number of drop-down boxes in this section varies depending on what you selected in the drop-down box above.

And about this drop down box:

First it will ask you to choose whether it is a column from an event or a property:

For more information on what properties are you can check out this section of the documentation
As far as a column from an event is concerned, it's the specific columns, measures, etc. that are present in the visual object you're creating Reflex for.

If you select an Existing property, there is generally only one drop-down box below to choose to switch to a different Existing property:

If you select a column, then it will ask you to select which column or measure and the scope of that column or measure.

At this point, the two drop-down boxes below correspond to the second level of selection (columns or measures) and the third level of selection (scopes) that you made previously.

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.