I have a usecase for visualising predictions in addition to the actual data. For example: we want to draw a graph that shows the total amount of users and we also want to draw it n months into the future using something like Facebook’s Prophet.
One way to accomplish this would be to generate data into the future and just graph that. However, the UI would’nt do a very good distinction between “this data is real” and “this data is forecasted” (unless, maybe draw two lines where the other one is the forecast and starts from where the other ended?)
Another way would be that metabase supported having two separate queries from two separate data sources in the same graph (AFAIK not possible atm.).
I have enough time and clojure skills to dig into metabase’s sources - however, I’d like to hear more from experienced people. What do you think would be a good way to do this with Metabase?
ps. I’m also looking at Grafana for this as they can support this.
Here’s a picture that hopefully clarifies what I’d like to accomplish.