Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
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.
"
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
Please add [ANombre Equipement Down] calculation.
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |