Month: December 2016

Guest Blog: Worm Charts

Harsh Budhiraja is a process engineer/metallurgist in Australia using Spotfire for real-time data processing and decision making. We are happy to feature him on datashoptalk as a guest blogger!

Worm Charts or (Actual vs Target Charts) are useful in a production environment where you want to see the cumulative production against planned production for a certain period. In Excel, they are easy where you have more control over things at Row level. But since the requirement was for the user to update it with date inputs, they had to be built in Spotfire with all the database connections.

See this example:

Read More

Technical Director at Ruths.ai

Spotfire Troubleshooting — CustomQuery: ‘TableName’ was not allowed to execute because it is not trusted

  • Have you run into a problem where a data table won’t open and is showing the error ‘The CustomQuery: ‘TableName’ was not allowed to execute because it is not trusted?’

Read More

Guest Spotfire blogger residing in Whitefish, MT.  Working for SM Energy’s Advanced Analytics and Emerging Technology team!

Spotfire – Insert, Calculated Column vs Insert, Transformation, Calculate New Column

  • Have you experienced issues joining with calculated columns?
  • Have you experienced issues getting calculated columns to work with pivot and unpivot?
  • Have you ever wondered why insert, transformations, calculated column is even an option?

Read More

Guest Spotfire blogger residing in Whitefish, MT.  Working for SM Energy’s Advanced Analytics and Emerging Technology team!