Explains Stuff
Explains Stuff
  • 12
  • 102 008
Set the Visualization Area Size (for iPad) in Spotfire
This is one of those features that always seems to be overlooked until someone actually points it out when someone's getting started with Spotfire. Whenever you're creating visualizations, Spotfire assumes that it wants to take up the entire window with your different charts. However, what if you're designing something that's not meant for just a regular computer screen? What if it's meant for a large display in a lobby? What if it's meant for an iPad?
If you go to the Document Properties, you can set the Visualization Area Size to iPad Portrait, iPad Landscape, or Custom Size. The default is Fit To Window, but that may not always be what you want.
www.explainsstuff.net/blog/visualizationareasize
มุมมอง: 1 825

วีดีโอ

Coordinates in Shapefiles | Using Data Functions in Spotfire
มุมมอง 4.1K10 ปีที่แล้ว
This is a use case that I feel like I run into pretty frequently. I have coordinates for a list of restaurants in San Francisco, and a I have an ESRI Shapefile of neighborhoods in San Francisco. However, I have no way to combine them to show what restaurants are in what neighborhoods....until my friend Ian Cook wrote me a Spotfire Data Function. In this video, we go through the use case of comb...
Installing CRAN Packages in Spotfire
มุมมอง 5K10 ปีที่แล้ว
Sometimes, when people write R scripts, they'll use CRAN (cran.r-project.org/) packages to do a very specific type of analysis. CRAN packages have directly contributed to the wild success of the R language. In this video, I show how to install CRAN packages from in a Spotfire environment. It's essentially the exact same thing as installing into any other R environment. spotfire.tibco.com/trial
Personalized Information Links (Row Level Security) in Spotfire 6.5
มุมมอง 24K10 ปีที่แล้ว
This is a simple walk through of a common approach to creating row level security using Spotfire 6.5. By using an extra look up table, the user name of the current user can be passed into the query as part of a WHERE clause.
Enabling Action Logs for Spotfire 6.5 (Windows / SQL Server)
มุมมอง 7K10 ปีที่แล้ว
Action Logs in Spotfire 6.5 are actually a standard part of the Spotfire stack, but I feel like you really don't hear about them much, even though they're extremely useful. You don't need to install them, but doing so is extremely easy and gives you a ton of visibility into what's happening in your Spotfire deployment.
Spotfire 6.5 - NYC Open Data 311 In-Database Example
มุมมอง 3.2K10 ปีที่แล้ว
This is one of my favorite demos because it really shows just how easy it can be to use Spotfire to combine in-memory and in-database tables. Using the NYC Open Data dataset for 311 calls since 2010, I show how you can build up to a meaningful visualization with no coding of any kind. The only thing you would need to recreate this demo is a shapefile of NYC, the 311 data ( nycopendata.socrata.c...
Creating a Timeline using a Scatter Plot in Spotfire
มุมมอง 11K10 ปีที่แล้ว
This is a video that I made as a response to a person on TIBCOmmunity about Spotfire. It was done using Spotfire 6.5. tibbr.tibcommunity.com/tibbr/#!/messages/96231 This video contains examples of: Adding rows to a table by using Excel and the Clipboard. Calculated Columns using OVER statements. Calculated Columns using CASE statements. Using a scatter plot with categorical data. Sorting catego...
Using Property Controls in Spotfire Axis Selectors
มุมมอง 6K10 ปีที่แล้ว
This video was made as a response to a posting on TIBCOmmunity.com https: tibbr.tibcommunity.com_tibbr_#!_messages_96569
Generating XML from a Spotfire Table using R
มุมมอง 1.7K10 ปีที่แล้ว
Demonstration of using a custom script in R to generate XML from a data table in Spotfire.
Spotfire 6.5 - Creating Alternating Colors in a Table Visualization
มุมมอง 8K10 ปีที่แล้ว
Quick tutorial on how to create the affect of alternating row colors in a table visualization in Spotfire.
Using R To Set Document Properties in Spotfire
มุมมอง 15K10 ปีที่แล้ว
Handy trick that I use to be able to set Document Properties in Spotfire 6.5
Using R in Spotfire 6.5 to add a custom line to a bar chart.
มุมมอง 15K10 ปีที่แล้ว
I found a customer on TIBCommunity that had an interesting problem, so I decided to see if I could take a crack at it. I couldn't immediately figure out how to solve his problem using the Spotfire Expression Language, so I did a two line R script instead.

ความคิดเห็น

  • @fahimnislam
    @fahimnislam 2 ปีที่แล้ว

    You da man!

  • @foggybottomz
    @foggybottomz 3 ปีที่แล้ว

    Woohoo, you taught me how to write my very first R script! Thank you for sharing this!

  • @jamesbautista6105
    @jamesbautista6105 3 ปีที่แล้ว

    hi, in 5:55 is it possible to use a document property (string list) as an input?

  • @unladpinoytv
    @unladpinoytv 3 ปีที่แล้ว

    my company is paying spotfire with thousands of dollars yet there is no simple way to create a timeline chart or a ganttchart lol this is ridiculous

  • @kiranraja2554
    @kiranraja2554 3 ปีที่แล้ว

    Hey , can you please share on how to use configuration block in spotfire ? Iam trying to pass a URL from an external application to spotfire report which would filter value accordingly in the report based on the parameter passed through the URL from an external application.

  • @TN02V2401
    @TN02V2401 4 ปีที่แล้ว

    Row Level Security using SPOTFIRE... good info Bro

  • @unladpinoytv
    @unladpinoytv 4 ปีที่แล้ว

    os there a version of this for spotfire x

  • @johannvisser7659
    @johannvisser7659 4 ปีที่แล้ว

    Can't explain how useful this was! Thank you so much

  • @senthilnathaneswaran9278
    @senthilnathaneswaran9278 5 ปีที่แล้ว

    Useful

  • @sanishthomas7911
    @sanishthomas7911 5 ปีที่แล้ว

    Hi , I tried creating a stored procedure with on Demand option and for the stored procedure I have kept a parameter which will be the current user name from python code which will be passed to the stored procedure and join with the main data table and master user table and retrieve data for that user. it is working on the client version , not sure if this works in the server version or runs fine in Webplayer. Please confirm Also do these users have access to the spotfire server or also to the DB where I am creating this stored procedure.

  • @SemipreciousGems
    @SemipreciousGems 5 ปีที่แล้ว

    I have a suggestion: For reducing the amount of data that is pulled into the dashboard, it is better to the join with permissions table in the dashboard (relationship + filter join enforcing).

  • @kul1993
    @kul1993 6 ปีที่แล้ว

    Hi, it seems that you install the package locally. Do you know what happens when you want to share this dashboard with someone who does not have these packages installed? Thanks!

    • @SuperMarkusparkus
      @SuperMarkusparkus 5 ปีที่แล้ว

      The TERR package will need to be installed on the client which opens the file otherwise the TERR function won't run. If the other Spotfire client is connecteed to the same Spotfire server environment it is possible (for a server admin) to upload TERR packages to the server so every client connecting to the Spotfire server can download the TERR packages locally on his machine. Alternatively under Tools > Options > data function (or via a server preference) it is possible to point out a TIBCO Spotfire Statistics Services server (Or TERR Server Edition) that will take care of the execution. In this case the package will need to be installed only centrally, assuming the data function is set to execute centrally on this server.

  • @victoriaeagle
    @victoriaeagle 6 ปีที่แล้ว

    Thank you for this video. I had task to calculate average figure from several calculated values that were calculated by using data from different tables. I knew very little ablut how to save calculated value into a document property and I knew nothing about R. Your video helped me with this seemingly impossible task :)

  • @windbreakerlkb4040
    @windbreakerlkb4040 6 ปีที่แล้ว

    its helpful if u share your file in the description so we can follow

  • @nandadk314
    @nandadk314 6 ปีที่แล้ว

    Can we capture action logs for IL's which through errors or does not have data in it??

  • @XXX-eh1ct
    @XXX-eh1ct 7 ปีที่แล้ว

    Hi I tried to install tm package in spotfire following your turtorial, I am running spotfire 7.6, it installed Rcpp, NLP, slam packages pretty quickly, but it stucked at installing the BH package.... any thoughts

  • @shilpakale4198
    @shilpakale4198 7 ปีที่แล้ว

    Excellent demo, many thanks for sharing this ! This worked for me in 7.6 version of Spotfire !

  • @marioustxexcel6375
    @marioustxexcel6375 7 ปีที่แล้ว

    Thank you

  • @chetanmayne5614
    @chetanmayne5614 7 ปีที่แล้ว

    Fantastic Video ! Thanks..

  • @roshansinghp
    @roshansinghp 7 ปีที่แล้ว

    Thank you so much, extremely useful!!!

  • @sairama307
    @sairama307 7 ปีที่แล้ว

    could you please provide me how to install spotfire server on windows, it is really helpful

  • @kjburgess11
    @kjburgess11 7 ปีที่แล้ว

    This doesn't work in 7.5 or greater versions of Spotfire.

  • @3piecechickendinner1
    @3piecechickendinner1 7 ปีที่แล้ว

    Clutch! this process also works for 7.5, thankfully!

  • @godsonchikelu6024
    @godsonchikelu6024 8 ปีที่แล้ว

    can you show how to use the googlevis motion chart with spotfire? M1 <- gvisMotionChart(Fruits, idvar="Fruit", timevar="Year") plot(M1)

  • @leegrant9957
    @leegrant9957 8 ปีที่แล้ว

    Are you aware of any data functions that create polygons with a specific radius around a point, or better yet a polyline? I'm trying to create representative area around oil and gas wellbores. Thanks!

  • @alangunn7254
    @alangunn7254 8 ปีที่แล้ว

    That's a great video! Thanks! :-)

  • @JNRix1
    @JNRix1 8 ปีที่แล้ว

    An alternative way is to modify the SQL. In this code I have not modified any of 'B1' column elements and since I am not returning any 'B2' column elements there is no reason for me to create 'B2' column elements. I just modify the Sql for the Information Link. SELECT B1."NAME" AS "NAME", B1."POSITION" AS "POSITION", B1."CAREER_AT_BATS" AS "CAREERATBATS", B1."CAREER_HITS" AS "CAREERHITS", B1."CAREER_HOME_RUNS" AS "CAREERHOMERUNS", B1."CAREER_RBIS" AS "CAREERRBIS", B1."CAREER_RUNS" AS "CAREERRUNS", B1."CAREER_WALKS" AS "CAREERWALKS" FROM "spotfire_demodata"."dbo"."BASEBALL" B1 JOIN "spotfire_demodata"."dbo"."Baseball_Permissions" B2 on B1."TEAM_87" = B2."Team_87" WHERE B2."UserName" = %CURRENT_USER%

  • @smitty1e
    @smitty1e 8 ปีที่แล้ว

    This is a great effort. One possible refinement would be to show how length of days could be tied to a start date, so that the x-axis could have the interrupt value displayed as an actual date. Then, when you've got all of the dependency lines on there, too, you can succeed in re-inventing a Gantt. ;-)

  • @sudeeppandey8200
    @sudeeppandey8200 8 ปีที่แล้ว

    Great Presentation...

  • @90awdturbo
    @90awdturbo 8 ปีที่แล้ว

    Your videos are so helpful, and they make me look so good. Thanks so much :)

  • @ziadAlkhailani
    @ziadAlkhailani 9 ปีที่แล้ว

    can you edit an information link to restrict the amount of data being uploaded making it faster? like having it only look 12 months in the past

  • @tigranyeremyan7634
    @tigranyeremyan7634 9 ปีที่แล้ว

    Hello, I was wondering if you knew how to create a combination chart that combines a simple bar char with a scatter chart. Thank you!

  • @saichand999
    @saichand999 9 ปีที่แล้ว

    Hi Tim,I can't able to find the link to install the SP package in the Spotfire.Please guide me how to install it, and in the video you have shown SHAPE file and done DRAG & DROP on graph.How we can create Shape file. Could you explain please.My mail id is: sairama90@gmail.com

  • @KenGray
    @KenGray 9 ปีที่แล้ว

    extremely so actually! thanks.

  • @AhmedAbdelsalamHBK
    @AhmedAbdelsalamHBK 9 ปีที่แล้ว

    how can i download spotfire server?

  • @abhinavvrajj
    @abhinavvrajj 9 ปีที่แล้ว

    Excellent.. really helps!! Thanks.

  • @sandyprabhu2004
    @sandyprabhu2004 9 ปีที่แล้ว

    That was really helpful . Thanks

  • @KALVARTHY
    @KALVARTHY 9 ปีที่แล้ว

    one can hardly hear the audio and see the formula exactly! please put the formula in description atleast

  • @venugopalcatari6896
    @venugopalcatari6896 9 ปีที่แล้ว

    this vedio not audiable

  • @andriimandzii1543
    @andriimandzii1543 9 ปีที่แล้ว

    Thanks for the video. But I have one question: Are the Personalized Information Links work with cache ?

  • @sachinzgupta
    @sachinzgupta 9 ปีที่แล้ว

    It is great to this kind of utility. The further link provides the R function which can be used in spotfire to convert the data points to have information from shape file. But unfortunately, it has pre-requisite to have sp package installed in Spotfire. I will be grateful if can help me directing to link or information which provides details to install the sp package in Spotfire. My email id is sachinzgupta@gmail.com

  • @vikasverma471
    @vikasverma471 9 ปีที่แล้ว

    thanks for the video

  • @lucadefalco5639
    @lucadefalco5639 10 ปีที่แล้ว

    Thank you for the video. I have a question : Is possible to know which page visits a user in a dxp?

  • @rohitbhatia24
    @rohitbhatia24 10 ปีที่แล้ว

    Hi, I was trying to do something similar to this. Instead of a one single horizontal line, I am looking for a bullet graph kind of a representation. Say, each bar represents metric for a single person in a group and the small horizontal line for each bar showing the average, and there are multiple bars each represented by a city or so. Do you think this is possible?

  • @rohitbhatia24
    @rohitbhatia24 10 ปีที่แล้ว

    Hey, I am a spotfire developer and I have not worked on 6.5 yet, but this demo was really nice. I have become a big fan of yours after watching your videos.. Kudos..

  • @jenniferbrown6780
    @jenniferbrown6780 10 ปีที่แล้ว

    Could you share the formula? It's hard to read on the video. Great tip, thanks!

    • @KenGray
      @KenGray 9 ปีที่แล้ว

      Jennifer Brown mod(rowid(),2)=0 but I use baserowid so that it works with filtering and sorting

    • @KenGray
      @KenGray 9 ปีที่แล้ว

      Jennifer Brown mod(rowid(),2)=0 but I use baserowid so that it works with filtering and sorting

    • @vijaybhaskar7016
      @vijaybhaskar7016 8 ปีที่แล้ว

      could you explain how BaserowId() works different than RowId(), I see both are giving same results. RowNumber not changing dynamically on the selection from default filters.

  • @BIMoji1
    @BIMoji1 10 ปีที่แล้ว

    This is a great stuff with R integration in SPOTFIRE.. Got a quick question for you. How did you created a Distance range filter along with the latitude & Longitude on the text area. Thanks, Vidya Sagar Malla

  • @cbuieostate
    @cbuieostate 10 ปีที่แล้ว

    Tim great work! Would you be willing to share the data function you used to achieve you analysis? It would be great to see the dxp or a video on how you set up the visualization. Thanks!

    • @ExplainsStuff
      @ExplainsStuff 10 ปีที่แล้ว

      Glad you liked it Chris! I'm actually going to be putting together a video that explains this in more detail, and will be putting up the resources. When I publish it, the resources will be available on ExplainsStuff.net :)

    • @cbuieostate
      @cbuieostate 10 ปีที่แล้ว

      That's fantastic, it is greatly appreciated!

  • @SatishVorkady
    @SatishVorkady 10 ปีที่แล้ว

    Excellent demo,Thanks

  • @BIMoji1
    @BIMoji1 10 ปีที่แล้ว

    Its really fantastic....Good Job