Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have below table with ID, Status and TimeStamp. I would like to get count of ID for last 24 hours and last 365 days by filtering over the text in Status column.
ID Status Timestamp
ZZ09 Allowed for first- 32 1-2-2019 7:00
ZZ09 Allowed for first- 44 1-2-2019 8:15
ZZ09 Left for first - 33 1-2-2019 9:15
ZZ09 Allowed for first- 26 1-2-2019 18:00
ZZ10 Working for first- 44 1-2-2019 8:15
ZZ10 Left for first - 33 2-2-2019 9:15
ZZ10 Working for first- 32 3-2-2019 7:00
ZZ11 Error for first- 44 1-2-2019 8:15
ZZ11 Last schedule for first - 33 1-2-2019 9:15
ZZ11 Error for first- 90 1-2-2019 8:30
ZZ11 Error for first- 89 1-2-2019 10:15
So I want count of ZZ09 where status is "Allowed for first" and for ZZ10 where status is" Working for first" and for ZZ11 where status is" Error for first". and so on for different IDs.
Then I would like to get a count on the number for last 24 hours and last 365 days. Please let me know what steps to be followed in this case.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.