Dr. Spotfire Session Summaries
Last updated:
11:47am Oct 18, 2018
Table of Contents

Back to Dr. Spotfire Landing Page

Past Dr. Spotfire Session Summaries:

August 2018

Summary

This session of Dr. Spotfire presented by DivyaJyoti Rajdev, Senior Data Scientist at TIBCO Software Inc featured expert Khushboo Rabadia. Discover what Dr. Spotfire's online office hours has to offer by registering for a live session. And that's not all! If you are ready to showcase interesting visuals and gain deeper insights into your data, join the conversation on Twitter using the #DrSpotfire hashtag and then post your question to the TIBCO Community "Answers" section with the hashtag #DrSpotfire. Register here: https://community.tibco.com/wiki/doct...

Quick Jump Times

  • 01:40 Caching in Spotfire
  • 04:05 Dxp Caching using Scheduled Updates
  • 07:06 Disk Caching
  • 10:10 Caching Data in Spotfire Analyst
  • 19:46 Caching Data using Information Link
  • 25:24 Incremental Caching
  • 35:06 Q1: Show top N values and Group Everything Else as ‘Other’
  • 37:08 Q2: Primary Y-Axis Descending Order and Secondary Y-Axis Ascending Order
  • 38:55 Q3: Can I create a hidden text area to store CSS code?
  • 42:45 Q4: Creation of Graphs in Spotfire
  • 50:28 Q5: User unable to view ‘Add New Tables’ option within Spotfire Analyst
  • 53:00 Q6: Creating slope on Decline Curve for boundary dominated flow

Q1. Show top N values and Group Everything Else as ‘Other’

  • A user is interested in showing the top N values in a barchart compared with everything else in one group. Now if we want to create a barchart which shows the top 5 states versus the rest, we need to:
  • Create a barchart with Sum(Value) on the Y axis and [State] on the X axis
  • Edit the expression on the X axis to:"<If(DenseRank(Sum([Value]) OVER ([State]),"desc")<=5,[State],"The Rest")>"
  • In order to make sure the Top 5 is calculated dynamically, set the X-axis to "Evaluate Axis on-> Current filtering only" (from the properties for the Category Axis, or by right click on the category(X) axis scale).
  • For more information see: https://community.tibco.com/wiki/show-top-n-vs-rest-spotfire

Q2. Primary Y-Axis Descending Order and Secondary Y-Axis Ascending Order

  • Create initial combination chart as seen in the video
  • Navigate to properties, select Y-Axis
  • Choose the option for individual scales
  • From the drop down under individual scale settings select the axis of interest and mark reverse scale. There are also a number of other options to customize your visualization

Q3. Can I create a hidden text area to store CSS code?

  • First some sample CSS code is shown. Then two solutions are outlined. First you can hide the navigation pane and control what users are allowed to access each page.
  • The second solution is a simpler workaround. First insert property control into a text area.
  • Select input field and create a new document property in the form of a string.
  • Paste the CSS into the document property
  • In a new Text Area insert a new property control and select Label.
  • Select the document property containing the CSS as the Label’s text and click Ok

Q4. Creation of Graphs in Spotfire

Q5. User unable to view ‘Add New Tables’ option within Spotfire Analyst

  • In this case the user does not have access to the proper permissions
  • Simply navigate to tools -> Administration Manager -> Groups and Licenses
  • Select the desired group from left and click the licenses tab
  • From there edit and enable licenses. If this does not fix the issues please raise a support ticket.

Q6. Creating slope on Decline Curve for boundary dominated flow

  • A user was working with the decline curve template available on the community
  • Navigate to the properties of the visualization, Under X-Axis select log scale
  • Next select Lines and Curves
  • Add a curve with expression equal to x (y(x): x)
  • Last, navigate to the Y-Axis and select log scale
  • It is noted that Spotfire supports more complex expressions for custom lines and curves.

July 2018

Summary

This session of Dr. Spotfire presented by DivyaJyoti Rajdev, Senior Data Scientist at TIBCO Software Inc featured experts Stu Blair and Minerva Dutta. Discover what Dr. Spotfire's online office hours has to offer by registering for a live session. And that's not all! If you are ready to showcase interesting visuals and gain deeper insights into your data, join the conversation on Twitter using the #DrSpotfire hashtag and then post your question to the TIBCO Community "Answers" section with the hashtag #DrSpotfire. Register here: https://community.tibco.com/wiki/doct...

Quick Jump Times

  • 02:04 The rise of the data artist by Stu Blair
  • 05:35 Visual Design and Best Practices
  • 09:00 Custom Styling and Developer Tool
  • 27:15 Donut plot in TIBCO Spotfire using Map Charts
  • 34:00 Using existing CSS/JavaScript animation elements in Spotfire
  • 38:05 Q1: Why doesn’t my CSS work in Spotfire?
  • 40:15 Q2: Using Videos in Spotfire
  • 42:30 Customizations in Spotfire and Mashup Example

Donut Chart using Map Chart

  1. Add new map chart and maximize the visualization to give yourself more room to work with
  2. Turn off the map layer added by default from layers under the map chart properties
  3. Navigate to positioning and select coordinate columns, using an expression set the coordinates to (1,1)
  4. Move to Colors and select categorical for the column of interest
  5. Next select size and under shapes set to pies. Select uniquecount for the size by category of the column selected earlier.
  6. Next add a duplicate layer to the map chart layers
  7. This is to create the ‘Donut hole’, so set the size to be slightly smaller than the first
  8. Set the color of the middle circle to match your background color to give the effect of a Donut Chart
  9. For expanded instructions please visit: https://community.tibco.com/wiki/donut-plot-tibco-spotfirer

Q1. Why doesn’t my CSS work in Spotfire?

  • Most of the time it is because HTML Sanitation is enabled.
  • To disable start the administration manager
  • Select the preferences tab
  • Select a group on the left pane. Use the Everyone group to set this for all users.
  • Click edit
  • Expand the TextArea > TextAreaPreferences
  • Set the PerformHtmlSanitation to ‘False’
  • Restart Spotfire to commit the change

Q2. Using Videos in Spotfire

  • Create a text area
  • Right click and edit html and JavaScript:

var d1 = document.getElementById("player");
console.log("found the 'player' div");

ifrm = document.createElement("iframe");
ifrm.setAttribute("src", "https://youtube.com/embed/xftdo_ls3WY?controls=0");
ifrm.style.width = "420px";
ifrm.style.height = "315px";
d1.appendChild(ifrm);

var sp = document.getElementById("toggle_player");
console.log("found the 'player' toggler");
sp.onclick = function() {
  dd = document.getElementById("player");
  if (dd.style.display == "block" || dd.style.display == "") {
    dd.style.display = "none";
  } else {
    dd.style.display = "block";
  }
}

HTML

<div id="topic_content">

<div class="topic_title">Using videos in Spotfire</div>

<div style="margin-top: 15px;">

To learn how to make a drill-down, watch this video <a id="extlink" href="https://www.youtube.com/watch?v=xftdo_ls3WY">in your browser</a>, or view it on <span id="toggle_player">this page</span>, below.

</div>

<div id="player" style="margin-top: 30px; display: none;"></div>

</div>

 

June 2018

Summary

This session of Dr. Spotfire featured Divya Jyoti Rajdev, Data Scientist at TIBCO Software Inc along with Peter Shaw Staff Data Scientist at TIBCO Software inc. Discover what Dr. Spotfire's online office hours has to offer by registering for a live session. And that's not all! If you are ready to showcase interesting visuals and gain deeper insights into your data, join the conversation on Twitter using the #DrSpotfire hashtag and then post your question to the TIBCO Community "Answers" section with the hashtag #DrSpotfire. Register here: https://community.tibco.com/wiki/doctor-spotfire-office-hours

Quick Jump Times

  • 02:00 Featured Speaker – Peter Shaw – Dynamically Visualizing self-organizing maps (SOMs) in Spotfire
  • 06:30 univariate and bivariate analysis on map charts
  • 09:25 2D Plots
  • 11:00 3D Plots
  • 12:55 K-Means Clustering
  • 15:00 Self-Organizing Maps
  • 34:00 Q1: How to loop through columns in a table and get their names?
  • 37:50 Q2: How to input multiple data tables into a TERR data function?
  • 40:50 Q3: trouble implementing the heat map data function from the community exchange
  • 51:28 Q4: What is the difference between manage relationships and column matches?
  • 56:50 Q5: Select multiple points on a map based on a similar column?

Q1: How to loop through columns in a table and get their names?

  • A simple data function can provide the desired results:

Q2: How to input multiple data tables into a TERR data function?

  • After navigating to edit->Data function properties and either creating a new or editing a script, users can type an input into the script window then highlight it and right click to declare as an input parameter. This can be done with more than one inputs. It is also pointed out that Spotfire will automatically cast inputs as data frames so there is no need to manually do so.

Q3: Trouble implementing the heat map data function from the community exchange

Q3: What is the difference between manage relationships and column matches?

  • Divya Jyoti points out that it is basically that your column relations are used to propagate for choosing and marking and your color matches are used to match the table so that you can use the data from multiple tables and the same visualization.
  • An example is then shown in the video.

 

Q4: Select multiple points on a map based on a similar column?

  • The solution suggested uses two map chart visualizations. You have one visualization with the name of the filter of whichever data point you want to select, that controls the marking of the map.
  • Next you make sure each map chart has the same marking. Now you can select chain one, you can see that all the locations get highlighted. Not only that, but it can be done backwards.
  • Its a very nice two-way transaction that can be used  over and over where you have a KPI chart that is configured to just select the value.

May 2018

Summary

This session of Dr. Spotfire featured Divya Jyoti Rajdev, Data Scientist at TIBCO Software Inc. Discover what Dr. Spotfire's online office hours has to offer by registering for a live session. And that's not all! If you are ready to showcase interesting visuals and gain deeper insights into your data, join the conversation on Twitter using the #DrSpotfire hashtag and then post your question to the TIBCO Community "Answers" section with the hashtag #DrSpotfire. Register here: https://community.tibco.com/wiki/doctor-spotfire-office-hours

Quick Jump Times

  • 00:35 Featured Speaker – Neil Kanungo Topic: GIS and Custom shapefiles
  • 01:00 GIS Background Information
  • 04:00 Creating custom shapefile demo
  • 11:00 Bringing it into Spotfire
  • 26:20 Spotfire Advantage in GIS
  • 31:06 Live Chat Question
  • 32:29 Live Chat Question
  • 32:53 Q1: how to create a candlestick chart in Spotfire?
  • 39:36 Q2: How to use Iron Python to create a new page and set the height and width of each visualization on the new page?
  • 45:49 Q3: Are there TERR equivalents of the dplyr and tidyr CRAN packages?

Live Chat Question: How to relate two data columns?

  • You can navigate to edit data table properties and manage relations. Then you need to click apply after creating the relation. From there you can use x and y values from data table b within a visualization based on table a given their relation.

Live Chat Question: What is the difference between column matching and a relation.

  • Simply put column matching allows you to use the column from a different table in filters while relations allow you to use them in visualizations. For more information on this see the next Dr. Spotfire session.

Q1: how to create a candlestick chart in Spotfire?

  • First, for features not out-of-the-box in Spotfire please submit ideas to the Spotfire Idea Portal at idea.tibco.com
  • A work around is provided by creating a stacked bar chart. Import the data as a tall type for the open and close. Or after importing the data unpivot it to tall. Then by placing the ID or whichever categorical variable you have on the x axis and the measure on the y axis you can color by the open and close and set the open to be transparent. This results in a visualization very similar to a candlestick, another option can be to create a custom visualization in d3.js

Q2: How to use Iron Python to create a new page and set the height and width of each visualization on the new page?

Q3: Are there TERR equivalents of the dplyr and tidyr CRAN packages?

  • In Spotfire 4.5 and up these packages can be directly used in TERR. In previous versions of Spotfire you can import the packages from TRAN instead of CRAN. https://tran.tibco.com/terr43

April 2018

Summary:

This session of Dr. Spotfire featured Divya Jyoti Rajdev, Data Scientist at TIBCO Software Inc. Discover what Dr. Spotfire's online office hours has to offer by registering for a live session. And that's not all! If you are ready to showcase interesting visuals and gain deeper insights into your data, join the conversation on Twitter using the #DrSpotfire hashtag and then post your question to the TIBCO Community "Answers" section with the hashtag #DrSpotfire. Register here: https://community.tibco.com/wiki/doctor-spotfire-office-hours

Quick Jump Times

  • 02:00 Overview Spotfire 7.12
  • 03:11 PDF Export Enhancements
  • 04:02 Cross Table Enhancements
  • 05:30 Map Chart Marker Directions
  • 11:00 Export to Image and PowerPoint improvements
  • 17:40 Data Wrangling
  • 28:28 Q1. Formatting a straight line expression
  • 32:36 Q2. How to place Value labels on a Bullet Graph?
  • 39:35 Q3. How to import XLS file with merged cells?
  • 43:50 Q4. How to create new Columns with Normalized data?
  • 48:49 Q5. What is the difference between data functions and expression functions?

Q1. How to format the display of a straight line expression?

  • The user would like the formula for the line displayed on the visualization to be accurate up to 10 decimal places instead of only showing 4. This can be done by first changing how the label is displayed by navigating to label and tooltip from Properties.
  • Then by checking the curve name under the Label Column. Next from the lines and curves tab edit the line to have a custom curve name instead of automatic. By doing so you can now change the curve name to whatever your desired value is.

Q2. How to place Value labels on a Bullet Graph?

  • There is no direct solution but there is an alternative workaround. From properties go to Color Ranges and insert relative color ranges based on your data. You can then add other values of interest of custom expression that will then display the values in the tooltip when you hover over. From Properties then Axes -> settings you can edit what shows in the tooltip.

Q3. How to import XLS file with merged cells?

  • The user wants to replace the empty values that were the result of a merge in excel. After importing the XLS file navigate to the data panel. From there select the column of interest and under the replace empty value with option select ‘Value immediately before’. Then repeat for any other columns.

Q4. How to create new columns normalized data?

  • Insert transformation and choose Normalization. Choose the columns you would like to apply the normalization to. Select a normalization method of your choice. Click okay and the normalized columns are created. For more information on normalization visit community.tibco.com.

Q5. What is the difference between data functions and expression functions?

  • First transformations are covered. For expression functions navigate to edit-> Data Function Properties -> Select the Expression Functions tab. To create a new expression function select new. The advantage is that the expression function is not tied to specific inputs or outputs so it can be reused without any manual work.
  • You can create a data function from register data functions. When you run it, you will have to map the inputs and outputs and every time it runs it will run with that specific mapping. Data functions are used for more complex calculations.

February 2018

Summary

This session of Dr. Spotfire featured DivyaJyoti Rajdev and Dr. Vishakha Mujoo, Data Scientists at TIBCO Software Inc. Discover what Dr. Spotfire's online office hours has to offer by registering for a live session. And that's not all! If you are ready to showcase interesting visuals and gain deeper insights into your data, join the conversation on Twitter using the #DrSpotfire hashtag and then post your question to the TIBCO Community "Answers" section with the hashtag #DrSpotfire. Register here: https://community.tibco.com/wiki/doct...

Quick Reference Times

  • 2:00 Live Demo of Kerberos Authentication in Spotfire - WIKi Article
  • 26:00 Q1. Calculating net working hours between two datetime stamps
  • 31:14 Q2. Convert multiple column values
  • 40:30 Q3. Specific Expression Function for calculating net present value
  • 48:40 Q4. How to connect two points with a line in a Scatter Plot
  • 52:50 Q5. How to score a model in Spotfire

Question One: How to calculate net working hours between two datetime stamps?

  • For a specific problem like this users won’t find the exact answer online. First they will need to create the algorithm that solves the problem then using Spotfire documents and resources learn to implement in Spotfire. Steps for question will look like this:
  • Assume Date columns Date1, Date2, where Date1 is older than Date2
  • Find week of year using ‘Week()’, as K1, K2
  • Weekends between Date1, Date2 = K1 - K2 -1
  • Days in each weekend = 2
  • Weekend Days total between Date1, Date2 = 2*(K1 - K2 - 1) (If K1 > K2, otherwise use year and week to manually change)
  • Time span between Date1, Date2 = DateDiff(Date1,Date2)
  • Total Days between Date1,Date2 by using TotalDays() on timespan from step 6.
  • Working days = Remove Weekend Days as Total Days from step 7. minus Weekend Days from step 5.
  • Working Hours ( excluding first and last working day) = (Working days from step 8 - 2) * 10
  • Check whether ‘Hour()’ of Date1 > 8 and <18 if yes H1=Hour(Date1) - 8 otherwise 0
  • Similarly for Date2
  • Total working hours = Working hours from step 9 + H1 + H2

Questions Two: How to convert multiple column values?

The user is wondering the best approach for converting multiple columns from the imperial to metric system. The first solution uses the insert transformation method. Then using the calculate and replace transformation users can use the expression language to make the conversion. The draw back for that approach is users will have to do it for each column.

The second approach involves using an expression function similar to data functions. This can be found from navigating to data functions then the expression function tab. Using the column function type you can enter the expression for the conversion and save it. Now going to insert calculated column you can select the expression function just created. The difference between these two approaches is that the first approach will stay linked including for in database. The advantage for expression functions is that they are not tied to inputs which improves the ease of reuse.

The third approach is using data functions. The advantage here is after creating the data function you can apply it to columns in batch as well as utilize advanced and more complex calculations.

Question Three: User has a calculation for net present value but it is resulting in empty values.

In order to figure out what is going wrong debugging is demonstrated. Divya Jyoti points out that the user is trying to calculate values based on a cross table in a data function. But, what the data function uses for the calculation is the underlying data table from the cross table not necessarily the values displayed.

In this situation it will be easier to use an expression function since they are not tied to your input. After creating the calculation in the expression function the user will have to specify the aggregation for the cross table by adding an as statement at the end of the expresion. Another way of using the data from the cross table and not the underlying data table is by exporting the data from the cross table visualization and using that as a new data table.

Question Four: How to connect two points with a line in a scatter plot?

From properties the user can navigate to line connection. There users can define the line connection based on columns.The points are now connected but since they are so close it is hard to see. By adding a Y zoom slider users can then zoom in and see the connecting lines.

Question Five: How to score a model in Spotfire?

Using an example model Divya Jyoti shows building a model and saving it to disc or a common network location. Next using an R script in Spotfire it can be loaded and then predicted from. The second way would be using web services and Score using REST calls. The final method is to represent the model as a platform independent PMML, POJO, PFA, etc. From there users can use an event engine such as TIBCO StreamBase to channel incoming data streams and predict.

January 2018

Summary

This session of Dr. Spotfire featured DivyaJyoti Rajdev and Dr. Vishakha Mujoo, Data Scientists at TIBCO Software Inc. Discover what Dr. Spotfire's online office hours has to offer by registering for a live session. And that's not all! If you are ready to showcase interesting visuals and gain deeper insights into your data, join the conversation on Twitter using the #DrSpotfire hashtag and then post your question to the TIBCO Community "Answers" section with the hashtag #DrSpotfire. Register here: https://community.tibco.com/wiki/doctor-spotfire-office-hours

Quick Reference Times

  • 01:55 Question 1: How can I customize JSViz samples?
  • 05:00 D3js
  • 11:30 Building a custom visualization in Spotfire based on a D3 sample
  • 44:10 Question 2: Individual KPI title based on column title
  • 48:00 RGraphics in Spotfire Example
  • 52:50 Question 3: How to toggle between two mapcharts?

Q1. How can I customize JSViz samples?

  • The JSViz extension is available free at community.tibco.com. This is useful for creating custom visualizations not available out of the box in Spotfire.
  • There are several visualization samples created that come shipped with the extension. Or for additional already created visualization you can find the source code at https://github.com/d3/d3/wiki/Gallery and bring it into Spotfire as shown.
  • All of these visualizations still allow for bidirectional marking and drill downs.

Q2: Individual KPI title based on column title

  • As of Spotfire 7.6 KPI charts are available.
  • The solution is to navigate to the KPI chart’s properties then to Values on the side menu. From there you can right-click the value axis drop down list and click custom expressions.
  • No additional custom expressions are needed. Instead you can enter a new display name from this menu which will serve as the KPI chart column title.

Q3. How to toggle between two mapcharts?

  • The recommended solution is to create a layout bookmark.
  • Bookmarks are snapshots of the state of an analysis. Add a bookmark to your analysis to be able to return to a state where you found something interesting when you marked or filtered out certain items. A bookmark can be applied at any time, allowing you to quickly return to a previously created view of the data. You can also share your insights with others by making your bookmarks available to other users, or by sending links to the bookmarks.
  • The demonstrated solution links two bookmarks in a text area via action control to allow users to toggle the mapchart.

Decemeber 2017

Summary

This session of Dr. Spotfire featured DivyaJyoti Rajdev and Dr. Vishakha Mujoo, Data Scientists at TIBCO Software Inc. Discover what Dr. Spotfire's online office hours has to offer by registering for a live session. And that's not all! If you are ready to showcase interesting visuals and gain deeper insights into your data, join the conversation on Twitter using the #DrSpotfire hashtag and then post your question to the TIBCO Community "Answers" section with the hashtag #DrSpotfire. Register here: https://community.tibco.com/wiki/doct...

Quick Reference Times

  • 01:30 Spotfire Export to PDF
  • 03:41 Spotfire 7.6 Recap
  • 07:05 Updated KPI Charts
  • 08:50 New mapping features
  • 13:28 New Tables and Cross-tables Functionality
  • 15:11 TERR Update and Example
  • 18:00 New Edit Data Transformation Feature
  • 20:22 Replace Value How-to
  • 22:10 Automation Services Enhancements
  • 24:41 Data Connections Enhancements
  • 26:55 Question 1: How to overwrite properties with user selection buttons
  • 32:38 Question 2: Highlighting a row on a graphical table
  • 36:40 Question 3: How to add a toggle button in Spotfire
  • 43:20 Chat Question 1: Handling duplicate values in Spotfire
  • 46:17 Question 4: Is it possible to hide the axis on a Spotfire Visualization
  • 50:37 Question 5: Configuring Kerberos with Spotfire

Q1. How to overwrite properties with user selection buttons?

  • The first solution uses one input field to capture the user’s new value for a property.
  • When the button is clicked a simple iron python script updates the property value with the input field’s value.
  • This can be used in more sophisticated manners such as to have the user input a column name.

Q2. Highlighting a row on a graphical table with a color

  • The first solution only applies to numeric data. Instead of using a graphical table you can create a cross table and show the same data. From there you can edit the Colors in the properties menu to assign colors for specific values or ranges.
  • The second and recommended solution uses a bar chart instead for better data visualization. This allows for more customization such as Trellis, Color by, and drill-downs.

Q3. How to add a toggle button in Spotfire that changes its text when clicked?

  • The solution starts by creating an html button. From there a JavaScript element is inserted which includes the code needed to change the text when clicked. • Divya Jyoti then points out that you can incorporate data from your analysis into the function using iron python if desired.

Chat Q1. Handling duplicate values in Spotfire

  • The user wanted to know how to consolidate duplicate values by variable and then sum the total value.
  • Dr. Vishakha Mujoo demonstrates using a pivot data transformation to create a new table.
  • The configuration of the row identifiers and aggregations methods is shown to sum each value by category.
  • The result is a consolidated view of the original table that handles duplicates and sums as requested.

Q4. Is it possible to hide or change the axis on a Spotfire Visualization?

  • By navigating to the properties then to the value axis you can edit minimum and maximum range of the axis.
  • There are also options to include origin or to show multiple scales.

Q5. Configuring Kerberos with Spotfire 

  • Questions related to specific implementations of Spotfire or the web player and administration are not covered in Dr. Spotfire Sessions. But for those questions the team creates articles or other resources to help available at community.tibco.com. In the case of Kerberos configuration please visit here.

October 2017

Summary

This session of Dr. Spotfire featured DivyaJyoti Rajdev and Dr. Vishakha Mujoo, Data Scientists at TIBCO Software Inc. Discover what Dr. Spotfire's online office hours has to offer by registering for a live session. And that's not all! If you are ready to showcase interesting visuals and gain deeper insights into your data, join the conversation on Twitter using the #DrSpotfire hashtag and then post your question to the TIBCO Community "Answers" section with the hashtag #DrSpotfire.

Quick Reference Times

  • 02:20 Raising the bar with effective Bar Charts
  • 09:30 Enriching Configurations
  • 15:33 Bullet Charts, Deviation Bar Charts, and Waterfall Charts
  • 22:15 Common Configuration Mistakes
  • 26:47 When not to use Bar Charts
  • 29:00 How do I learn more about Bar Charts?
  • 30:13 Question 1: How to use data from two separate data columns in one visualization
  • 35:50 Question 2: How to export PDF
  • 38:00 New Rotation Markers
  • 41:00 Question 3: Change data source of visualization along with properties based on user selection
  • 48:45 Question 4: Connecting to OSIsoft – PI with Spotfire

Q1. How to use data from two separate date columns in one visualization

  • The user has two tables with different date and value columns and would like to visualize the data on one x-axis.
  • By inserting the rows from one table onto the other and using the match columns we can join them onto one table without merging the data. Basically, just appending the data since it will not match.
  • Next by changing the color by to the new column and by adding both variables to the y-axis, both columns are displayed on one x-axis.

Q2. How to export as PDF

  • The export to PDF feature is shown including the new functionality as of Spotfire 7.10.
  • Not only will exported visualizations retain the visual theme of the dashboard, but they will be of higher graphical quality. In addition, the export dialog now has a preview to ensure best results. That's not all — there is now a relative scaling option that allows you to adjust the text in your visualizations to best fit your PDF page.

Q3. Change data source of visualization along with properties based on user selection

  • One user wanted this accomplished using a script which is shown. Another user prefers not using a script.
  • For the case of not using a script Dr. Vishakha Mujoo demonstrates how to use bookmarks to achieve this.
  • Not only can bookmarks be used to save filter settings and organization but page layout and visualizations, active page and or visualization, markings, and properties. • Lastly, in order to share the bookmarks must be set to public. Q4: Connecting to OSIsoft – PI with Spotfire • Connecting to OSIsoft – PI with Spotfire is made easy with the data connector which can be downloaded from https://community.tibco.com/wiki/gett...
  • From there Dr. Vishakha Mujoo shows how to configure the data source, select any tags, or point sources and connect.
  • When the analysis is connected to source it will always be updated with the latest data when opened.