Skip to main content
Question

LiveInsights Formulas

  • June 22, 2026
  • 1 reply
  • 145 views
S

Hello!

Has anyone figured out a formulas for the following:

  • How many reps have not created a DSR? (aggregate and list of users)
  • Showing usage of content for reps including zeros based on a certain tag during a certain time period

I’ve tried adding what I know to get zeros and I’ve tried taking off all filters. I still can’t even seem to get a complete list of what I need or even a complete list of everyone in the user group.

1 reply

hannah_smith
Forum|alt.badge.img

I’ve used this formula to count the views on a particular asset, and it will show 0 for a given user if they have 0 views. You could choose another type of action category besides views though. 

 

(Count ([ID]),All([NORMALIZEDNAME]), All([Years in OCCURREDAT]))
*0 + (count([ID1]),[ACTIONCATEGORY],[NORMALIZEDNAME1])

 

ID = from the Users table

ID1 = from the UserActivity table

OCCURREDAT = from the UserActivity table

ACTIONCATEGORY = I have this set to Views but you could set it to Usage

NORMALIZEDNAME1 = filtered for the particular asset I’m looking at

 

I have this formula as a value, and I have the users’ email and other properties as rows. I’m thinking you could probably play around with this to get it to work for assets that have a certain tag. Let me know how it goes!

 

    Terms & ConditionsAccessibility statement