Address discrepancies between visualizations, tables, and other data displays (date/time displays and calculations, etc.)

[ccostino]

We've noticed a few areas where the visualizations and tables we have on our dashboards are not quite in sync with each other and leading to confusion on our team and with our partners. These are things such as:

• Which timezone is being used to display message send times?
• Which messages are being included in the counts? Only succeeded and delivered? Also failed? What about pending?
• Are the ranges accurate?

We ought to spend some time making sure that the data we're showing is accurate, correct, and labeled properly with relevant units/measurements.

Things that need more correct labeling

• Add pending message data to daily and user_daily stats #2199
• Provide a tooltip or caption explaining what each table represents. #2200
• When a user schedules a job, they should see "scheduled" instead of "sent" on the Service Activity page #2168
• Update/Revise status banner on confirmation page #1706

UTC/Local/TimeZone data display discrepancy

• Message status, daily chart, & All Activity chart - stats should be the same? #2204
• Needs investigation: On the confirmation sent page, the scheduled time is showing as 1 month in advance. #2202
• There is still confusion about 'local time.' It’s not clear which time is being displayed. #2201

[heyitsmebev]

This is what I've gathered

[ecayer]

Thanks for gathering this, @heyitsmebev !

Are we all agreed on matching up the Total Messages count with the Recent Activity chart by including Pending messages on the Recent Activity chart? (@terrazoon's suggestion from https://gsa-tts.slack.com/archives/C0107UC0W1M/p1733325721677589) cc @stvnrlly @jonathanbobel @CathyBeil

Other changes needed:

• the Recent Activity chart should be in the user's timezone
• the job status for scheduled jobs should give "Scheduled for" and the scheduled for time (or be removed from the table. My personal preference would be to keep it and make it accurate)

[heyitsmebev]

@ecayer

The "Total Messages" chart displays chargeable units as messages sent. Does "chargeable units" have the same meaning as "delivered messages"?

If we do want to add and display pending messages, we'll also need to add update these endpoints:

get_service_notification_statistics_by_day
"/service/{0}/statistics/{1}/{2}".format(service_id, start_date, days)

get_user_service_notification_statistics_by_day
/service/{0}/statistics/user/{1}/{2}/{3}".format(service_id, user_id, start_date, days),

[CathyBeil]

Related pages with possibly-related issues:
Activity page shows a "Time Sent"...

...clicking on the Job ID shows a very different time scheduled (which I don't think is accurate, since it's not possible to schedule 1+ month in advance):

[ecayer]

Need term definitions & it will need backend work.

[heyitsmebev]

Adding this ticket to this epic: When a user schedules a job, they should see "scheduled" instead of "sent" on the Service Activity page #2168