[TC_AUTHOR_SUMAC_6] Course Comparison Video Engagement charts show no data

[pomegranited]

The Video Engagement table on the Course Comparison Dashboard shows no data, even though I have completed 2 videos in the DemoX course.

I tried enabling completion by adding the completion.enable_completion_tracking waffle flag, but it had no effect on these charts -- they still show no data.

[Ian2012]

@pomegranited can you confirm as a superuser if the table has data? Can you share screenshots? Is it empty on all three dashboards?

[saraburns1]

This is probably due to the memory overload. I'm really close to having a solution but have been running into some environment issues. Hoping to have it fixed by EOW

…

On Wed, Nov 13, 2024 at 9:54 AM Cristhian Garcia ***@***.***> wrote: @pomegranited <https://github.com/pomegranited> can you confirm as a superuser if the table has data? Can you share screenshots? Is it empty on all three dashboards? — Reply to this email directly, view it on GitHub <#296 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BIR4DO5PFDXCJXNMDRGLSKD2ANR2VAVCNFSM6AAAAABRTELQ4OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINZTHA2DQMZWGE> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[Ian2012]

I don't think that's the problem, I've tried running the MV SQL and its not working for video_playback_events_mv

[pomegranited]

@Ian2012

Can you confirm as a superuser if the table has data?

xapi.watched_video_duration (and xapi.watched_video_duration_mv) have 0 rows on the sumac test server.

Can you share screenshots?

Posted screenshot of the empty chart in the issue description, or you can see for yourself on https://superset.sumac.demo.edly.io ; superuser here.

Is it empty on all three dashboards?

Course Dashboard > Engagement > Videos and Individual Learner > Videos show up fine -- there's data in xapi.section_video_engagement, reporting.fact_video_plays and xapi.video_playback_events.

The At-Risk Learners > Engagement > Videos is empty because no users meet the at-risk criteria, so I don't know about that one.

[Ian2012]

@saraburns1 is reviewing this issue. The SQL returns the values but the MV is not being populated

[bmtcril]

I think this is related to the right side join not triggering the MV. This should be solved in Sara's PR. 🤞

[bmtcril]

Ok I think v1.3.0 will solve this. I'll ask for the Sumac sandbox to be updated with it on Monday.

[saraburns1]

@pomegranited - this is updated in the Sumac sandbox now, can you double check and close this issue if everything looks good?

[bmtcril]

I believe @pomegranited is on vacation for a while. I've confirmed this is working on the sandbox now, so will close this out: