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 calculate : Actual down - eventdown + event up
If I use a graphic, no problem, I have number by day and time.
But, I would like, for example select 30/07 and know haw many device is down. With a card I have a number but I would like to have a max value.
How can I have a max from a calculate (my values are calculated and not are in column) ? Or get value according to the date ?
Thanks for your help
5 Replies
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 calculate : Actual down - sommeeventdown + somme event up
If I use a graphic, no problem, I have number by day and time.
But, I would like, for example select 29/07 and know haw many device is down. With a card I have a number but I would like to have a max value (104)
How can I have a max from a calculate (my values are calculated and not are in column) ? Or get value according to the date ?Here an example :
Thanks for your help
Anonymous ,
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.Please add [ANombre Equipement Down] calculation.
