WebDataRocks轴序

Question

所以，我有个命令

Green,0,0,0,0,0,0
Black,0,0,0,0,0,0
Red,0,0,0,0,0,0,0
Blue,0,0,0,0,0,0,0

生成webdatarocks时显示

Blue,0,0,0,0,0,0,0
Black,0,0,0,0,0,0
Green,0,0,0,0,0,0
Red,0,0,0,0,0,0,0

有没有办法让它们按顺序显示，而不是按字母顺序显示？我现在能想到的就是给他们一个数字前缀…

Answer 1

我认为在配置片时可以使用“排序”属性来解决这个问题。您需要在report对象中预定义它。我对示例使用了JSON数据：

const pivot = new WebDataRocks({
        container: "#wdr-component",
        toolbar: true,
        width: "100%",
        height: 300,
        report: {
    "dataSource": {
        "dataSourceType": "json",
        "data": [{
            "Color": "Green", 
            "Data1": -1,
            "Data2": 0,
            "Data3": 0
        },
        {
            "Color": "Black", 
            "Data1": 0,
            "Data2": 0,
            "Data3": 0
        },
        {
            "Color": "Red", 
            "Data1": 0,
            "Data2": 0,
            "Data3": 0
        },
        {
            "Color": "Blue", 
            "Data1": 0,
            "Data2": 0,
            "Data3": 0
        }]
    },
    "slice": {
        "rows": [
            {
                "uniqueName": "Color",
                "sort": "unsorted"
            },
            {
                "uniqueName": "Data2"
            },
            {
                "uniqueName": "Data3"
            }
        ],
        "columns": [
            {
                "uniqueName": "Measures"
            }
        ],
        "measures": [
            {
                "uniqueName": "Data1",
                "aggregation": "sum"
            }
        ],
        "flatOrder": [
            "Color",
            "Data1",
            "Data2",
            "Data3"
        ]
    },
    "options": {
        "grid": {
            "type": "flat",
            "showGrandTotals": "off"
        }
    }
}
    }
);

<link href="https://cdn.webdatarocks.com/latest/webdatarocks.min.css" rel="stylesheet"/>
<script src="https://cdn.webdatarocks.com/latest/webdatarocks.toolbar.min.js"></script>
<script src="https://cdn.webdatarocks.com/latest/webdatarocks.js"></script>

<div id="wdr-component"></div>

​

可以将JSON数据替换为对端点的引用。好像他们在文档里有这样的例子。