• Push cube aggreagation to server side
• Support optional configuration to push aggregation to data source for JDBC

增加对每个维度的排序功能，默认升序
排序之后可用于表头合并
下面截图USA被分开

For now, all the drag and drop column for chart configurations will be reset when chart type changed.
It will be more user friendly keep the config to avoid repeat DAD.
But chart configuration are not the same.
e.g. : KIP chart should only have one value column, line/bar chart can have 2 value axis ..
In order to handle this diversity, optional chart configuration should like below:
According to current drop status, enable the supported chart type, disabled not supported chart type:

Above pic is only a reference, the final effect shall prevail.

Refactor sort and OLAP aggregation algorithm.

For now, if the size of header keys or column keys is more than 5W, performance of data service will be very low with high latency because of insert-sort algorithm.

The combined cells of header should share sample ancestors.
Below is a error combine example, CNY below ES and FR shouldn't be combined

Use parameter component,table widget lost style
before:

after:

As of now when result data are too big, web page performance will be effectively infected. It's necessary to add a paging function for the big table.

_Dashboard_里面_Widget_数据缓存之后，第二次访问不能自动刷新

是否会考虑加入cohort图表？
方便进行留存分析
有部分功能与 re:dash 相似

Thanks for the awesome project!
widget designer,when filter select a chinese option,save and reopen,can't find the selectd option

Add data connection test

Should allow duplicated widget name or data source name under different category

看板编辑中，选择列对应的图表之后名称默认显示图表名称，可以更改

Wrong pop position when Maxim widget as blow:

图表设计里面，值轴上面的聚合表达式上面只能实现预先定义的集中聚合方式

显示中往往需要对集合之后的列进行数学运算，如：sum(a)/sum(b)，类似于Mondrian里面定义的CalculatedMeasures

• Add user and role management module
• Add resource management module
• Add board level ACL management module
• Add ACL management of system System Menu/DateSource/DateSet/Widget
• UI tuning
• Add change password page

新建图表的时候可选使用

• 已经固化查询
• 采用原有图表设计方案

User interactive and program logic as below

Parameter usage

前提

由于列不区分维度和度量，不能够直接在所有列上面做可选过滤功能

限定

• 设定一个阈值，读取数据的时候默认对每一列的数值存放在对应的set里面，每次放入Set之前检查Set Size是否超过阈值，超过阈值则不保存

表格样式有问题，高度不能自适应，横向滚动条一直存在，不是按需存在

目前的表格插件不能展示交叉表的层级，理想情况希望能够实现类似下面这种能够合并行/列相同值单元格的效果

目前Dashboard布局设计的地方没有预览功能，每次设计好之后需要到看板展示的地方预览效果，来来回回调整不太方便
可以考虑

• 增加Dashboard预览功能
• 或看板展示的地方添加一个类似widge编辑的按钮，直接链接会看板设计

Preview container should be cleaned when new a widget, switch widget type and CANCEL button be clicked

table dashboard_role、dashboard_user、dashboard_user_role not exists...

For now, real time widget will not refresh data and filter on dash board also not apply on widget when maximization

1,表格数据样式丢失
实时刷新前

刷新后

Dear developer:

I have used cboard to show kylin data, but the data seems exhibit with logic bug, as the pic shows, "199407-" before "199401-", while I have ordered by year-month, this really confused me, please tell me why? And I changed a sql, there still exists this logic bug.

Thank you for your help!

Add new chart type

Datasource, DataSet, Widget are cascaded. As of now user can delete a datasource that depended on by data set and widget.
We should provide system level robust check and exception handler.

• Show dataset/query of the widget at board designer
• Prevent user delete resource that been depended on
• Exception handler
• Improve search function: search widget by dataset/datasource, search dataset by datasource

For now, the load data process will go directly to query fresh data from data provider. Sometime, when query is heavy the load latency will be very high.
It would be better to have a "use cache" checkbox or switcher along with load data button. Let user choice whether execute new query or just get cache data to avoid duplicate query.

refactor widget hierarchy with ngJstree

Configurable server side data cache between JVM and Redis

头部导航（layout-top-nav）

在body节点添加 layout-top-nav 类名,应该只有头部导航，没有侧边栏。
但是在代码中添加后，无变化。

When the chart type is cross table, allow user to set the format of each field, especially the thousands of decimal digits, percent sign, plus or minus style, left-right alignment, bold, italic, size, underline, etc. setting.

登录接口没有，如何进入主界面？？？

It better to pop a loading page after user sign in and before completing load all things.
It's more friendly than waiting without any notice.

Dashboard 展示性能优化

1. 前端请求Board定义
2. 前端获取后台Board定义，并分析Board提取QueryList
3. 前端并发异步请求Query数据，返回query数据串行图形渲染

Add group input in pie chart design form, plot one pie chart for each column

add embeded tomcat for developer
so developer can debug and start app in IDE