• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how can i get a measure for use with slice visor

adolpo

New Member
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


beside I create a table called days with values ( 1-31) for refers us to the days

days
1
2
3
.
.
.

my idea is to use a slicer visor with a measure and show only status off device 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
 
Top