Display Historical and Future Data in single report

Technical queries
#1

Hello Helical Team,

I am using Helical Insight 4.0. I have 2 tables in my database. One contains historical data and another contains future data that has been calculated using pythone algorithms. I would like to visualize this data in a single chart (like a trend). Is there a way to achieve this?

Thank You,
Kaji.

#2

Hello Kaji,

Helical Insight allows you to create views within the metadata. You can create a union between the 2 tables in one view and then use this view as a single table to create the report. So your view will have the both historical as well as future data which can be visualized.

Thank You,
Helical Insight.