Use SAP Analytics Cloud Analytics Designer Script Editor as Chart Data Source

We person a request to physique an SAC communicative that will:

1. Count the fig of caller attraction notifications
2. Count the fig of closed notifications
3. Count the fig of weeks a notification was open

Leveraging OData service C_ObjPgMaintNotification arsenic the Model, I person been capable to make further columns successful the exemplary that cipher the week based connected the date.  For example, a notification opened January 1, 2024 volition amusement a commencement week of December 31, 2023 and extremity week of January 6, 2024.  The aforesaid is existent for a completed notification.

I person utilized the SAC Analytics Designer to physique 3 key-value brace dictionaries that volition clasp the commencement week and the number of new, open, and closed notifications (newNotificationsByWeek, openNotificationsByWeek, and closedNotificationsByWeek).  New and closed notifications are casual to get arsenic they are dimensions successful the model.

For unfastened notifications, I person the SAC Analytics Designer loop done the notifications and adhd to the number for the respective week.  If we had a notification opened January 1, 2024 and closed February 1st, 2024 and a 2nd notification opened January 18 and closed January 29, the output would look similar this:

newNotificationsByWeek Sun Dec 31 2023: "1" Sun Jan 07 2024: "0" Sun Jan 14 2024: "1" Sun Jan 21 2024: "0" Sun Jan 28 2024: "0" openNotificationsByWeek Sun Dec 31 2023: "1" Sun Jan 07 2024: "1" Sun Jan 14 2024: "2" Sun Jan 21 2024: "2" Sun Jan 28 2024: "0" newNotificationsByWeek Sun Dec 31 2023: "0" Sun Jan 07 2024: "0" Sun Jan 14 2024: "0" Sun Jan 21 2024: "0" Sun Jan 28 2024: "2"

Now the contented that I person is however tin I usage the key-value pairs successful a chart?  I person tried to loop done them and usage API calls specified arsenic Chart.addDimension(), Chart.addMember, etc. but these look to lone let dimensions and measures that are portion of the model.  I looked to spot if determination was a mode to propulsion the values to a abstracted dataset oregon exemplary and usage that arsenic the chart, but that doesn't look to beryllium possible.

Is determination a mode to usage publication variables arsenic the chart's information root truthful that a barroom illustration with the day on the x-axis and number connected the y-axis tin beryllium viewed?