measure for aggregated faults percentage

[jitpbi]

Hi,

Please refer the below table as a sample dataset for my query:

Device	Status	DateTime
A	Healthy	10/21/2020   8:56:00 PM
A	Fault1	10/20/2020   6:24:00 PM
A	Fault2	10/21/2020   2:50:00 PM
A	Fault3	10/21/2020   3:47:00 PM
A	Healthy	10/21/2020   4:56:00 PM
B	Healthy	10/21/2020   2:16:00 PM
B	Healthy	10/20/2020   4:56:00 PM
B	Fault2	10/20/2020   6:15:00 PM
B	Fault3	10/21/2020   3:12:00 PM
B	Healthy	10/20/2020   8:03:00 PM

In the above table, device A has more faults than healthy status and device B has more healthy status than faults in the last 24 hours.

I want to create a measure on this which can let me know which device's status was more than 30% of faults in the last 24 hours. Also, I need to present this on the visual like "Device A has more than 50% of faults in the last 24 hours", so how to derive this measure and how to present on the visual as mentioned. 

Thanks

Thanks

[CNENFRNL]

Hi, @jitpbi , you might want to try this; a file is attached for your reference.

[jitpbi]

Hi @CNENFRNL ,

I can see Fault % for Device A is 60% and for Device B is 40% if we refer the SysLog table. Also, I need to show it like below:

"Device A is having 60% faults"

Thanks

[CNENFRNL]

@jitpbi , I didn't quite catch you; but I break down my idea to you,

1. pinpointing a date/time option for observation
   Synthesis of a date slicer and a "hh:mm of day" slicer (unfortunately, PBI so far doesn't support hour-level or minute-levle slicer) brings about a selected date/time; which makes your observation dynamic
2. calculation of fault %
   It's based on 24 hours before the selected date/time (e.g. 10/21/2020 3:00:00 PM in the dummy file) as you expected; that's to say, SysLog table is filtered down to a subset of records within this period