Display Forecast Cost

Hi Team,


I have a date column and a cost metric (End Date and Cost). The Requirement is to display month to date cost, calculate the projected cost for each remaining day of the month and display a line series for the (month to date + remaining dates) and its cost.


Can we achieve it in ThoughtSpot?If yes, kindly please guide us  for formulas?

8replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • You could use the integration with R to do this. 

    There is a Time Series Forecast R script pre-built that could be used. 

    Like 1
  • Thank you Marc Price , can you please guide on steps to enable R script for custom analysis

  • Siddhi Doshi that looks like SpotIQ you are trying to use. 

    you access R (if you have the privilege to access it) in the answer screen on the right hand side of the screen: 

    Like 2
  • Marc Price Thanks Marc for the details. I tried using the Time Series Forecast R script provided by TS, but no luck.

    Null Pointer Exception:

     1: "0f7c29df-f605-411e-947e-299647b2e391 user=aw_admin Error while processing request {}
        at com.thoughtspot.callosum.data.rdata.executor.RserverConnectionImpl.close(RserverConnectionImpl.java:179)
        at com.thoughtspot.callosum.data.rdata.executor.RdataExecutorImpl.stopRConnection(RdataExecutorImpl.java:145)
        at com.thoughtspot.callosum.data.rdata.manager.RdataManagerImpl.getRanalysisOutputs(RdataManagerImpl.java:219)
        at com.thoughtspot.callosum.data.rdata.manager.RdataManagerImpl.analyzeViz(RdataManagerImpl.java:124)
        at com.thoughtspot.callosum.data.manager.DataManager.getRscriptAnswerBookData(DataManager.java:2260)
        at com.thoughtspot.callosum.data.manager.DataManager.getReportBookData(DataManager.java:431)
        at com.thoughtspot.callosum.server.services.data.DataService.reportBookData(DataService.java:395)
        at sun.reflect.GeneratedMethodAccessor755.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
        at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
        at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
        at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)

  • you need to make sure you have selected your columns in the correct order, it should tell you in the script 

    Like 1
  • Marc Price Yes, i am following it.

    # The first column should represent some date column
    # and the second should be some numeric measure column.

  • ahh ok, 

    im not sure what it might be then. Maybe raise a support ticket? 

    or is it something you can do in ETL before moving it into ThoughtSpot? 

    Like 1
  • Marc Price  Thank you marc. I have raised a support ticket for it.

    For now, We will consider doing the forecasting in our ELT pipeline.

Like Follow
  • Status Answered
  • 4 mths agoLast active
  • 8Replies
  • 27Views
  • 2 Following