hi could you help me sorry my english is bad i have a question about of how can i get a measure for use with slice visor Any help would be greatly appreciated
i have a table with status like is showed here maq Status Timestamp dev1 on 10/27/2021 10:20 dev1 on 10/27/2021 9:20 dev1 on 10/27/2021 8:20 dev1 on 10/27/2021 7:20 dev1 on 10/27/2021 6:20 dev1 on 10/26/2021 21:20 dev1 off 10/26/2021 20:20 dev1 off 10/26/2021 19:20 dev1 on 10/25/2021 11:20 dev1 on 10/25/2021 10:20 dev1 on 10/25/2021 9:20 dev1 on 10/25/2021 8:20 dev1 off 10/23/2021 9:20 dev1 off 10/23/2021 5:20 dev1 on 10/22/2021 23:20 dev1 on 10/22/2021 19:20 dev1 on 10/21/2021 19:20 dev1 on 10/21/2021 14:20 dev1 on 10/20/2021 17:20 dev1 on 10/20/2021 12:20 dev1 on 10/19/2021 20:20 dev1 on 10/19/2021 18:20 dev1 on 10/18/2021 9:20 dev1 on 10/18/2021 7:20 dev2 off 10/27/2021 10:20 dev2 off 10/27/2021 9:20 dev2 off 10/27/2021 8:20 dev2 off 10/27/2021 7:20
my idea is to use a slicer visor with a measure and show me with only status off devices depending last N day selected
for example if you select
1 days
output dev2 dev3 dev4
if you select: 2
dev2 dev3 dev4
3 days dev3 dev4
thanks in advance any sugestion