The AI Assistant Conversations Per Month report shows the count of conversations with Dayforce AI Assistant for each month, ordered from most recent to oldest.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Month | Z to A | ||
| Year | Z to A | ||
| Conversations Count |
Custom Fields
Month
The Month custom field shows the month that AI Assistant conversations happened. It uses the following expression:
CASE WHEN MONTH(AiAssistantConversationODS.timestamp) <10 THEN CONCAT("0",MONTH(AiAssistantConversationODS.timestamp)) ELSE MONTH(AiAssistantConversationODS.timestamp) ENDDATE(AiAssistantConversationODS.timestamp)
Year
The Year custom field shows the year that AI Assistant conversations happened. It uses the following expression:
YEAR(AiAssistantConversationODS.timestamp)
Conversations Count
The Conversations Count custom field shows the total number of AI Assistant conversations. It uses the following expression:
COUNT(DISTINCT(AiAssistantConversationODS.conversation_id))
Filters
The template includes the following filters:
