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