Someone in my org has already built the default "baked in" Monitoring App this trailhead has you create before this step, and they built the datasets differently. As a result, I can't get this output in Prod when I join URI data to a dataset of a custom object. I get how many times various User Ids clicked an item, but not their names.
What I need to do is recreate the URIWithUsers that the trailhead automatically builds, and I'm trying to do it by figuring it out rather than just copying the JSON from my Trailhead in my Prod org (I'd like to actually learn it).
I've tried creating a new dataset / dataflow of just User.Id, User.FullName, and then doing a data recipe, both LOOKUP and LEFT JOIN, of the baked in URI data set and this User dataset, WHERE URI.User_Id_Derived = User.Id (full length Id, this feels right), and also WHERE URI.UserId = User.Id (this feels less right, but I'm desperate?), but I get no results on the right side.
I can clearly see in the URI data that my own user Id is clicking around in things (short form Id is under the USER_ID column, long form is under USER_ID_DERIVED), so I should be able to see my name on the right side. Instead I get no results for the right hand side of the join for every URI listed.
답변 2개
Actually I ended up figuring it out myself. Lack of functional knowledge around building dataflows. I ended up picking apart one that "worked" and doing a few more trailheads. Was missing an augment node.