Profile picture for user fuliggians

I have a datafeed containing this kind of data:

"country" "job_name" "value"

 

"DC", "DC-NSR-PC-A-NSR_REPORT", 2 "DC", "DC-BCV-PC-A-IAS_BCK", 1 "ES", "ES-DBA-PJ-A-HPIUMP_BK_ARCH", 14 "ES", "ES-NSR-PJ-A-SQL_ESWHA011", 1 "ES", "ES-DBA-PJ-A-STTIBCOP1_BCA", 29 "GR", "GR-DBA-PJ-A-SIEBEL7T_BKA", 58 "GR", "GR-DBA-TJ-A-ANALYTIT_BKF", 7 "GR", "GR-NSR-PC-A-RERP_BCK", 1 "IT", "IT-DBA-PJ-A-OV_NNM_BKF", 1 "IT", "IT-DBA-PJ-A-DST_BK_BACK_FULL", 2 "IT", "IT-DBA-PJ-A-BV190_BKF", 1 "PT", "PT-NSR-PC-A-SIEB8_B1_BCK", 1   I would like to create a mashapp where these data are not shown simply like data table but "grouping" the country. In this way:   DC DC-NSR-PC-A-NSR_REPORT  2 DC-BCV-PC-A-IAS_BCK           1   ES ES-DBA-PJ-A-HPIUMP_BK_ARCH 14 ES-NSR-PJ-A-SQL_ESWHA011      1 ES-DBA-PJ-A-STTIBCOP1_BCA     29   GR [.etc..]   ----------------------------------------------------------------   PS: I can not do this operation Manually using filter, because I don't know how many countries I can have in the dataset.
by Markus von den Driesch
Posted on Thu, 06/09/2011 - 17:34

Hi,

I created a specific feed that copied the country tag into the job_name column and then used this feed in a table.

Feed definition:

Sample output in the debug window:

And the resulting table in the viewer:

0
by dario borsotti Author
Posted on Thu, 06/09/2011 - 23:20

Thanks Markus,

you solution helps but my question was related mainly to the possibility in Mashzone to show data grouping them.

One very interesting feature should be the possibility of associate one column, or more (the group by one) to create title and group of data. I was thinking to one tipical feature of jasper report ( http://ireport-tutorial.blogspot.com/2008/10/ireport-group-by-report.html )

I would like to show data into mashapp, not through graphs, but with a report-like visualization.

 

    

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • MS
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock