Forum Discussion
Max from calcul
Hello, I have calculated a number device down on specific date and time I have a Event table with down and up events and a Node table (with actual down). And another calendar and time table. I ...
v-yuta-msft
Community Support
Community SupportAnonymous ,
Could you please share some dummy data and share more details about the expected result?
Regards,
Jimmy Tao
Hello,
I calculate number for each date :
ANombre Equipement Down is a measure
EventTime is a EventTime in table
ANombre Equipement Down EventTime 104 27/7/19 14:07 100 27/7/19 14:14 99 27/7/19 14:15 100 27/7/19 14:15 100 27/7/19 14:15 100 27/7/19 14:15 100 27/7/19 14:16 100 27/7/19 14:16 100 27/7/19 14:16 100 27/7/19 14:16 98 27/7/19 14:16 97 27/7/19 14:16 98 27/7/19 14:16 85 27/7/19 14:16 99 27/7/19 14:16 99 27/7/19 14:16 100 27/7/19 14:16 100 27/7/19 14:17 100 27/7/19 14:18 100 27/7/19 14:18 100 27/7/19 14:18 100 27/7/19 14:18 100 27/7/19 14:19 99 27/7/19 14:19 99 27/7/19 14:19 100 27/7/19 14:19 100 27/7/19 14:20 99 27/7/19 14:20 100 27/7/19 14:21 97 27/7/19 14:21 99 27/7/19 14:21 100 27/7/19 14:23 100 27/7/19 14:26 100 27/7/19 14:26 100 27/7/19 14:26 100 27/7/19 14:26 89 27/7/19 14:27 100 27/7/19 14:27 99 27/7/19 14:28 100 27/7/19 14:28 100 27/7/19 14:29 100 27/7/19 14:29 99 27/7/19 14:29 100 27/7/19 14:31 100 27/7/19 14:31 100 27/7/19 14:31 100 27/7/19 14:31 99 27/7/19 14:32 100 27/7/19 14:33 100 27/7/19 14:33 100 27/7/19 14:34 98 27/7/19 14:34 100 27/7/19 14:36 100 27/7/19 14:36 100 27/7/19 14:36 99 27/7/19 14:37 100 27/7/19 14:38 100 27/7/19 14:38 100 27/7/19 14:39 98 27/7/19 14:39 99 27/7/19 14:39 100 27/7/19 14:41 100 27/7/19 14:41 99 27/7/19 14:42 100 27/7/19 14:43 100 27/7/19 14:43 100 27/7/19 14:44 100 27/7/19 14:44 100 27/7/19 14:44 94 27/7/19 14:44 99 27/7/19 14:44 100 27/7/19 14:48 100 27/7/19 14:48 100 27/7/19 14:48 100 27/7/19 14:49 100 27/7/19 14:49 99 27/7/19 14:49 100 27/7/19 14:51 100 27/7/19 14:53 100 27/7/19 14:53 100 27/7/19 14:53 102 27/7/19 14:53 100 27/7/19 14:53 100 27/7/19 14:54 100 27/7/19 14:54 100 27/7/19 14:54 99 27/7/19 14:54 98 27/7/19 14:54 101 27/7/19 14:54 100 27/7/19 14:55 99 27/7/19 14:55 98 27/7/19 14:55 100 27/7/19 14:55 100 27/7/19 14:55 98 27/7/19 14:56 90 27/7/19 14:56 100 27/7/19 14:56 100 27/7/19 14:56 100 27/7/19 14:57 99 27/7/19 14:57 96 27/7/19 14:58 100 27/7/19 14:58 101 27/7/19 14:58 99 27/7/19 14:59 I would like to have the max value (for example 27/07 2PM)
If I use a card, I have 23.
I can't using max function because it is not a column but a measure.
So, I would like in card the max value from my table.
saykaskuResolver I
Please add [ANombre Equipement Down] calculation.
- v-yuta-msft
Anonymous ,
"
I would like to have the max value (for example 27/07 2PM)
If I use a card, I have 23.
"
<-- Could you clarify why the max value is 27/07 2PM and how can we acheve 23?
Regards,
Jimmy Tao