Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member186358
Active Contributor
0 Kudos

How about having live tweets on your dashboards, does that sound interesting!? I am sure it does 😉 just follow these 4 simple steps...

Next to these Twitter components you can simply add your visualizations....

Here is the Source File 

 

Below is the URL to get live Tweets in XML format, you need to replace User Name i.e. instead of BOXcelsiusUG have your twitter id.

http://twitter.com/statuses/user_timeline/BOXcelsiusUG.xml?count=2

 Step 1: In spreadsheet (in Xcelsius) click source and add XML Maps by passing this above URL.

Step 2: Drag required fields (Text, Screen Name, Profile Image URL) in spreadsheet and click refresh data, this will refresh spreadsheet with latest tweets.

Similarly if you want to add some more twitter IDs you can do that as well by adding XMLMaps in the workbook... 

Step 3: Now in data manager add Excel XML Maps connection, and it will automatically add connections,as shown below. 

 

Step 4: Add Refresh Connection button and check all the connections

Configuration part is done, now you have data in Excel sheet, so just use your creativity and develop a dashboard.

Happy Learning 🙂

1 Comment