Challenge #389: Password and Security Violations
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Maveryx,
A solution to last week’s challenge can be found here.
This challenge comes to us from @NicoleJohnson
Thank you for your contribution, Nicole!
Picture yourself as an auditor within a prominent financial institution. Your primary duty involves performing meticulous security audits across various software applications. This entails deciphering the extent of access granted to individual users based on the last password update and identifying instances of any breaches in security protocols.
In this challenge, your task is to determine the number of password and security violations attributable to each user. The dataset you are working with contains data for three distinct users. However, there is a slight complication: all the pertinent information is consolidated within a single column.
Hint: The number of password or security violations is indicated in parentheses following PSWD-VIO and SEC-VIO. For example, PSWD-VIO(2) indicates the user has two password violations and SEC-VIO(3) indicates the user has three security violations.
- Labels:
- Advanced
- Data Parsing
- Intermediate
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
C389
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My Solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, @NicoleJohnson! This was a neat challenge!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great one to solve with Designer, unfortunately got stuck in designer cloud (see spoiler what functions I think are missing in order to solve it on Cloud).
Cloud doesn't allow you to add a record ID without sorting so the sort order is lost upon any of the record id, make group, etc. Even if there was a row id to refer to, we wouldn't be able to use functions like remainder/MOD as those are not available in formula tools yet.