Me, Myself and MashZone

Hi Martin!

Looking forward the continuation of your story! I'v tried several times to create my own mashups based on my own data feeds, but somehow i haven't succeeded yet. :(

Couldn't find the answers I was looking for in the tutorials...

One of the mashapps i tried to 'bake' was a line chart, respresenting data from a feed that takes EURIBOR 3M rates data from a .xls file placed on the internet (here's the link to it: http://bit.ly/bcFN2w). The feed seems to gather the information. Don't know what i'm doing wrong, but the line chart resists to display it in a mashapp...

BR,

Edgars

Hi Edgars,

Thank you for your comment. I'll show you how I would do it.

First of all open the excel file and give the name "date" to the second row in the first column.

Then start a new MashApp and create a Time filter and a Line chart in the composer.

Now click on 'Assing Data' and create a new Data Feed. Choose your Excel file (http://bit.ly/bcFN2w) as Data Source.Take the column name from row 2 and import values from row 3. Then click on "Display calculation result" to see if everything is ok. It is important that the data types are set right. Otherwise change the data types via the operator "columns/Change data type".

Save your changes and go back to the Assign Data area. Connect the Data feed columns with the Line chart.

Then click on "Filter data" to connect the Time filter with your Line chart.

Select the Time filter and the data feed column "date" and set the condition "in selection" . Apply filter, save and close the assign data area.

Now you can use the Time filter to control the Line chart. If you want you can also add a legend to the line chart.

I hope this will help you.

Cheers,

Martin

Yes, indeed. It works exactly that way. ARIS MashZone even allows you to read the Excel sheet from the URL directly, i.e. you must not download and save it to disk manually. And MashZone will even receive update this way.

Martin - thank you very much! Your explanation is splendid and it helped me a lot indeed!

Although I encountered some unexpected 'obstacles' (like I had to change the data format, shorten the data row amount (with ARIS mash zone, you can have up to 1000 data rows observed in a data feed)), I made it through and now I have my first mashup!!! Yess!!! :)

I have to agree - in the end it really wasn't that complicated! Now I can't wait to add some other mashups and present it to my colleagues and friends!

Edgars

I am at the spot

Save your changes and go back to the Assign Data area. Connect the Data feed columns with the Line chart.

I do not get the list of columns to map from the data side to the line chart side.

Did I not set something right?

thanks

donald

Hey Donald,

did you click on "back to the composer" after you have created and saved your data feed?

Otherwise you have to choose your saved data feed in the assign data area.

Best regards,

Martin