Hello,
Looking for some advice on how to create an automated indicator that shows trending on the average of the "Latest AQI" scores.
In the kb_knowledge table there is a field called "Latest AQI". Great field, however it's a reference field so I can't do math on it. In order to populate this, there must be a business rule that looks at the Article Checklist Summary [kb_article_checklist_summary] table > aqi_score field, looks at all the records for a particular knowledge article, and finds the most recent on to populate this "Latest AQI" field in the kb_knowledge table.
Of course, when I create an automated indicator based on this field, it doesn't work because "Latest AQI" is a reference field. In the automated indicator source tab, I am not able to dot walk to the Article Checklist Summary [kb_article_checklist_summary] > api_score field - which would be a great solution if I could.
What do you recommend for how I can achieve this?
I wish I had better data to show you, but at least I have some good news for you. The AQI indicator that you're looking for is already part of the Knowledge Management content pack that's available from London forward:
It may be easiest to install the content pack for Knowledge. It's free as long as you have Performance Analytics, and it looks like you do. Once you've got the content pack, even if you don't want the whole dashboard, you're able to reuse all of the widgets, indicators, breakdowns and sources that come with it.
If you don't want or need the whole package, the way they're doing it is this:
Formula Indicator - Article Quality Index
Formula = [[Sum of AQI Scores - Monthly]] / [[Number of AQI Records - Monthly]]
Automated Indicator - Sum of AQI Scores - Monthly
Sum of 'AQI Score' field on KBArticleChecklist.Monthly Indicator Source
Add'l Conditions: State is Submitted
Automated Indicator - Number of AQI Records - Monthly
Count on KBArticleChecklist.Monthly Indicator Source
Add'l Conditions: State is Submitted
Indicator Source - KBArticleChecklist.Monthly
Facts Table is Article Checklist Summary (kb_article_checklist_summary)
Conditions: Created on This month
Hopefully this helps!
