It would be great if annotations can be created from a table of timeseries data instead of only via API calls.
What is the problem or goal the end user is trying to solve or accomplish?
Annotations can be used to overlay a history of events that explain the trends visible on a time series chart. Having annotations be dynamically updatable allows end users to have context automatically.
How are they solving it currently?
Currently, annotations are created via API calls, which is resulting in some ceilings and limitations
What is the recommended solution by the Customer?
If annotations can be created by a table, then the table will automatically update via ETL tools without the usage of the Preset API system.
You can add annotations via a table today. First create a table chart powered by a Google Sheet or a Database table:
Intervals Table
This chart will be used to list all intervals:
Events Table
Similar to the previous chart, now we’ll filter for event_type = 'Event':
Now, let’s add this data as Annotation Layers to a Chart - I’ll be using a Line Chart created with the Vehicle Sales example data.
When configuring my Annotation Layer, I’ll select Table as the Annotation Source, and then find the table chart I have just created.
This is the configuration for the Interval Annotation Layer:
This the configuration for the Event Annotation Layer:
This is the final result: