InPruthvi
3 years agoContributor
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