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.
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.