{"id":111454,"date":"2018-04-02T10:43:22","date_gmt":"2018-04-02T10:43:22","guid":{"rendered":"http:\/\/www.timestored.com\/b\/?p=111454"},"modified":"2018-04-02T10:43:22","modified_gmt":"2018-04-02T10:43:22","slug":"stacked-bar-charts-qstudio","status":"publish","type":"post","link":"https:\/\/www.timestored.com\/b\/stacked-bar-charts-qstudio\/","title":{"rendered":"qStudio now supports Stacked Bar Charts"},"content":{"rendered":"

qStudio has added support for stacked bar charts:<\/p>\n

\"\"<\/p>\n

The chart format<\/a> for this is: The first string columns are used as category labels. Whatever numeric columns appear next are a separate series in the chart. Each row in the data becomes one stacked bar. The table for the data shown above for example is:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
dt<\/th>\nLSE<\/th>\nBTS<\/th>\nNAS<\/th>\nASE<\/th>\nNYQ<\/th>\nSES<\/th>\nTSE<\/th>\nHKG<\/th>\n<\/tr>\n<\/thead>\n
2018-03-30<\/td>\n1047<\/td>\n2120<\/td>\n592<\/td>\n25<\/td>\n3660<\/td>\n303<\/td>\n225<\/td>\n383<\/td>\n<\/tr>\n
2018-03-29<\/td>\n1148<\/td>\n2118<\/td>\n528<\/td>\n10<\/td>\n3656<\/td>\n541<\/td>\n215<\/td>\n303<\/td>\n<\/tr>\n
2018-03-28<\/td>\n1201<\/td>\n2085<\/td>\n555<\/td>\n17<\/td>\n3644<\/td>\n302<\/td>\n290<\/td>\n339<\/td>\n<\/tr>\n
2018-03-27<\/td>\n1206<\/td>\n2182<\/td>\n535<\/td>\n21<\/td>\n3604<\/td>\n235<\/td>\n299<\/td>\n319<\/td>\n<\/tr>\n
2018-03-26<\/td>\n1239<\/td>\n2041<\/td>\n515<\/td>\n16<\/td>\n3549<\/td>\n251<\/td>\n234<\/td>\n363<\/td>\n<\/tr>\n
2018-03-25<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
2018-03-24<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
2018-03-23<\/td>\n1379<\/td>\n2115<\/td>\n595<\/td>\n29<\/td>\n3430<\/td>\n138<\/td>\n251<\/td>\n348<\/td>\n<\/tr>\n
2018-03-22<\/td>\n1431<\/td>\n2179<\/td>\n517<\/td>\n25<\/td>\n3399<\/td>\n531<\/td>\n222<\/td>\n320<\/td>\n<\/tr>\n
2018-03-21<\/td>\n1530<\/td>\n2032<\/td>\n558<\/td>\n29<\/td>\n3282<\/td>\n438<\/td>\n296<\/td>\n359<\/td>\n<\/tr>\n
2018-03-20<\/td>\n1531<\/td>\n2134<\/td>\n520<\/td>\n23<\/td>\n3256<\/td>\n515<\/td>\n265<\/td>\n322<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

You may need to “kdb pivot<\/a>” your original data to get it in the correct shape.<\/p>\n","protected":false},"excerpt":{"rendered":"

qStudio has added support for stacked bar charts: The chart format for this is: The first string columns are used as category labels. Whatever numeric columns appear next are a separate series in the chart. Each row in the data becomes one stacked bar. The table for the data shown above for example is: dt […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[2,92],"tags":[104],"_links":{"self":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111454"}],"collection":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/comments?post=111454"}],"version-history":[{"count":2,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111454\/revisions"}],"predecessor-version":[{"id":111457,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111454\/revisions\/111457"}],"wp:attachment":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/media?parent=111454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/categories?post=111454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/tags?post=111454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}