Question
Sykehuspartner HF
NO
Last activity: 27 Jan 2025 10:46 EST
How to Display Data from a Data Page in a Graph in Constellation?
Hello,
I have a requirement to display data from an API call in a graph. The dataset includes fields like date-time (for the x-coordinate) and valueA, valueB, valueC (for the y-coordinates).
In our application, which is being built in Constellation, we do not want to save this data to the database. Instead, we only want to cache the data in a Data Page and display.
We were able to achieve this in Cosmos by sourcing the graph directly from a Data Page in the UI. However, I am struggling to implement this in Constellation. From what I understand, Constellation seems to require saving the data to the database and then using Insights (?).
Is it possible to achieve this without saving the data and instead use the Data Page as the source? If so, how can this be implemented in Constellation? Any guidance would be greatly appreciated!
Thank you in advance!
HCA Healthcare
US
@JovanD16790232 you can display data from a Data Page in a graph in Constellation without saving it to the database. First, ensure your API call retrieves the necessary data, including date-time and valueA, valueB, valueC fields. Next, create a Data Page in Constellation to cache this data temporarily. Use JavaScript or a suitable scripting language within Constellation to fetch and store the API data in the Data Page. Then, add a graph component to your UI and configure it to use the Data Page as its data source. Map the date-time field to the x-axis and the valueA, valueB, and valueC fields to the y-axes of the graph. You might need to use Constellation’s built-in tools or custom scripts to bind the Data Page data to the graph dynamically. Ensure that the Data Page updates appropriately when new data is fetched from the API. If Constellation requires Insights for advanced visualization, check if Insights can directly read from the Data Page without needing to store data in the database.
Sykehuspartner HF
NO
@Sairohith Thank you for your advice. I understand the gist of it. I can configure the Data Page to retrieve the data, which works fine. However, as far as I can see, the only way to visualize this data is through Insights (?). It seems that the graph component is not available in Constellation. Could you please provide more specific guidance?
Pegasystems Inc.
IN
Basic criteria for a data page to show in an insight is - Report Definition as a source.
Hence , it is not possible to use the Data page without caching the data in DB.
One design approach can be to create a concrete class which acts as a bridge to load the data required for the insight. The data can be loaded prior using a QP in off business hours to keep it current and refreshed based on the business requirements. A data page sourced from a RD using this concrete class can then be used in an insight and represented in chart or graph format.
Sykehuspartner HF
NO
@Aditi Mehta Thank you for your answer! As per business requirements, we should not store the data in the application as this is GDPR data. However, let's say we do for this use case. Does this mean that I would have to delete all database entries after each call? Additionally, if multiple requestors across the region are trying to get the data, wouldn't this create a significant database overhead for such a simple use case? Would Constellation custom components be a viable solution here?
Pegasystems Inc.
IN
Sure, there will be database overhead in this design. If possible, we can delete the data at the end of the business day.
Using a custom component can be a viable solution but will have additional maintenance issues. Also, we need to manage caching and operations like grouping/sorting/filtering.