Skip to main content

I’ve created our own badge integration with Credly and I want to track total customer badges earned across the platform on a group dashboard for leadership. This means I have to capture data for each assessment tied ot the badge trigger and filter out internal employees.

I’m using tagging to accomplish this using the following parameters:

1. There are 2 ways to earn every badge: By either passing the pre or post test. However, some people are choosing to take both and passing both and I don't want to count individuals twice. So I need a way to count by the badge earned. My solution was to tag the assessments by the badge name and use a distinct count per tag, but I'm open to other methods and suggestions.

2. Badging is an integration and is triggered upon passing the above assessments, so it's not registered in TI. I can only use assessment passed to determine badges awarded.

Filters:

  • Email (does not contain) {employee email domain}
  • Assessments Passed = yes,
  • Content Tags Tag (is) {designated badge tag}

Data: {Content Tags Tag}  BY {learner detail count]

 

THE PROBLEM: It will not provide a sum total of learners by badge tag.  It takes the total number of learners for the first tag and stops there? I’ve tried using separate filtered group for each tag using the OR operator and get an even weirder outcome. It’s not configurable in the Visualization section either. I’m at a loss here.  I’ve added a screenshot below. I’ve tried to solve this with a filtered measure, but the query doesn’t acknowledge sum, distinct_count, or total? Can anyone help. TI’s reporting documentation is very basic and not helpful.  Would love to see an office hours or webinar on this.

 

HI Stacie,

Unfortunately this is the way that Looker works when you choose a display of type Number : 

the count of the first row will show, so what you will have to do is ensure that there is only one row in the grid. As you are searching and displaying two courses, each course will have its own row.
If you remove the Content Tag from the grid display so you only have one row then the 68 should appear in the tile.

If you want to PM me the name of the report i will have a look and see if i can work it out for you.

 

Warmest regards

 

Jon

Hi Jon, 

Thanks for the reply. I appreciate it.  68 would be incorrect as well (which is what I find weird in the calculation) It gives the sum of the first line and a count of the second. What I want is the SUM of 67 + 9 to show. It should be 75.

  • I have to group the badges awarded by tags since they can be issued on the pre- and post-test; that way, they are only counted once.
  • If I count assessments, that gives me a raw total of all passed assessments, despite the tagged grouping. 
  • If I use learner count, it groups all passes under 1 email, even if they’ve earned 2 badges, which doesn’t work either. 

I need to be able to calculate a sum. :( 

Reply


Terms & ConditionsCookie settings