Forum Discussion

InPruthvi's avatar
InPruthvi
Contributor
3 years ago

Topics data do not match with dashboard

Hello Developers,

I tried to pull the topics count for Month of Nov2021 and I see it is not matching with the dashboard's Topics KPI

Query I used to get topics count: 

SELECT COUNT (DISTINCT Topic_id) FROM khoros_messages
WHERE khoros_messages.post_time LIKE ('%2021-11%')
AND khoros_messages.conversation_style = 'forum' AND depth = "0"

Query answer: 1235

Dashboard value for Topics KPI: 1,358

Any help will be helpful to understand why numbers are not matching

Thank You

- Pruthvi

No RepliesBe the first to reply