Governance Dashboard Count of "out of session CALs"

[MalcolmCICWF]

I use Governance Dashboard as many do, but I couldn't find canned report where it shows the number of user errors where there are no session CALs available. I want to gauge how often it's happening, so I am trying to create a count field in the script. I have tried WildMatch and IF = statements, but nothing seems to have worked on a text string (even using * as a wildcard).

Anyone have a lot of experience with strings of text where if the 'Message' field is *out of SESSION CALS*, then 1, else 0? Or maybe something similar that should work? I am going to keep tinkering with it.

[neelamsaroha157]

can you share a screenshot when 2 is selected?

[neelamsaroha157 · Accepted solution]

This is what I am getting (I have used a different string as I don't have session cals in my dashboard).

[MalcolmCICWF]

So here is the crazy thing, I saw that you did it right in the list box instead of creating the field in the script behind the scenes... and THAT works. Same does not work when trying to create the field in script. Thanks for the outside the box help! I usually don't go about it this way. Appreciate it!

[neelamsaroha157]

Until you are using any aggregation function like sum or count, it shouldn't have value as 2. Simple if condition should return either 1 or 0 based on the expression.

[MalcolmCICWF]

I typically create some fields like this for simple counts in expressions. Just a Yes/No Indicator as 1/0 for summing later.

Either way it worked on the front end, thanks for trouble shooting with me.

[neelamsaroha157]

I am glad it worked .

But if you will create a flag with the same expression in the back end without using count or sum, it will give you the same results.

Good luck!!