Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
From a visualizing perspective: streaming (with history) datasets are just like normal datasets. You if you add a card visual containing an average of the column, it will show an average of all the records in the dataset. You can add filters to the visual/page/report to alter the calculation.
Usually by adding an timestamp to the dataset you can easily filter based on time, e.g. last hour. Another option is to add the time/date as an increasing number to the dataset as you can use the 'Top N' visual as filter to achieve a visual containing only the last event without a relative filter based on time.
-JP
From a visualizing perspective: streaming (with history) datasets are just like normal datasets. You if you add a card visual containing an average of the column, it will show an average of all the records in the dataset. You can add filters to the visual/page/report to alter the calculation.
Usually by adding an timestamp to the dataset you can easily filter based on time, e.g. last hour. Another option is to add the time/date as an increasing number to the dataset as you can use the 'Top N' visual as filter to achieve a visual containing only the last event without a relative filter based on time.
-JP