• 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.

get items according to status based on a date condition

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


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
 

adolpo

New Member
thanks for your time Sir

the idea is first step is group by dev and date and then compare them with respect to total off vs total day , if total day is equal to total status off by dev is true
note: before status were replaced by 1 ( off) and 0 ( on)

Row Labels datesdev1 offdev1 tottrue/false dev1dev2 offdev3 tottrue/false dev2dev3 offdev3 tottrue/false dev3dev4 offdev4 tottrue/false dev 4
10/21/202102FALSE12FALSE02FALSE02FALSE
10/22/202102FALSE02FALSE02FALSE12FALSE
10/23/202122TRUE02FALSE02FALSE22TRUE
10/25/202104FALSE25FALSE44TRUE44TRUE
10/26/202123FALSE33TRUE33TRUE33TRUE
10/27/202105FALSE55TRUE55TRUE55TRUE


after that ,we should have the output like is showed below using a slicer visor like dropdown , when you select some day , we refer last n days with fully true for this particular day

suppose today is ----->10/27/202110/27/202110/27/2021
when select visor slicer ---->234
output last N days with all status offdev2
dev3
dev4
dev3
dev4
dev4

I hope it is understandable

thanks in advance any suggestion
 

Attachments

Top