Identify User Status based on trend view

Hi Team,

Is there any way to identify via a QS calculation if a user is not in the current month, this user is inactive?

user proficiency sample

Hi @Li_Yang

you can calculate something like

ifelse(extract("MM",{Year-Month})=extract("MM",now()) AND isNotNull({Proficiency%}), 1, 0)

But not sure if you will get it in the pivot table as your SS is showing.


1 Like