Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (120 points)
I'm working with SQL data out of ServiceNow. I'm trying to create a visual for FLR percentage by supervisor by date. My FLR code reads:

[FLR %] = LEFT(AVG(CASE WHEN opened_by = resolved_by THEN 1.0
                  ELSE 0 END) * 100, 4) + '%',

Our version of FLR or first line resolution states that when an agent opens and closes and incident it's counted as first line resolution providing the re open count and reassignment count are equal to 0.

Every time I try to add this data to a visual it tries to turn it into a count. I'm trying to find a way to show it as a line graph where the FLR percentage is shown over time and each of the five supervisors is represented by their own 'dot'.

Please log in or register to answer this question.

Related questions

0 votes
1 answer
asked Mar 29, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Nov 24, 2020 in BI by Chris (11.1k points)

Browse Categories

...