d3.js的filter()方法未显示预期结果

4

筛选命令未按我的预期工作。如何重构代码以获得所需的输出结果?

.filter((d,i) => condition)语法中,d是一个带有该数据点的x(日期/时间字符串)y(该班次生产的汽车数量)轴值的对象,i是该数据点在折线图上的索引。为什么d.x != testdate#注意:testdate1testdate2是精确匹配数据点中两个日期/时间字符串的datetime字符串
在解决问题时,我还尝试查看了d.xtypeof,但没有成功。

测试1-已注释掉-与测试2和3相反,并且它有效(演示了因为显示圆点的代码而未匹配测试2和3中的条件)
测试2-无法在星期一1月04日08:00数据点上看到greendot类(简写语法)
测试3-无法在星期六1月02日08:00数据点上看到reddot类(传统语法,不同数据点)
测试4-类似于上面,使用console.log
测试5-测试typeof-console.log不显示任何内容,console.dir仅显示文本单词“object”
测试6-console.log显示其中一个数据点完全符合testdate1

用于实验的jsFiddle

clearconsole();
var chartWidth = 500;
var myCSV = [ 
{"shift":"1","date":"01/01/2016/08/00/00","car":"178","truck":"125","bike":"317","moto":"237"},
{"shift":"2","date":"01/01/2016/17/00/00","car":"125","truck":"189","bike":"125","moto":"273"},
{"shift":"3","date":"02/01/2016/08/00/00","car":"140","truck":"219","bike":"328","moto":"1252"},
{"shift":"4","date":"02/01/2016/17/00/00","car":"222","truck":"290","bike":"432","moto":"378"},
{"shift":"5","date":"03/01/2016/08/00/00","car":"200","truck":"250","bike":"420","moto":"319"},
{"shift":"6","date":"03/01/2016/17/00/00","car":"230","truck":"220","bike":"310","moto":"413"},
{"shift":"7","date":"04/01/2016/08/00/00","car":"155","truck":"177","bike":"377","moto":"180"},
{"shift":"8","date":"04/01/2016/17/00/00","car":"179","truck":"203","bike":"405","moto":"222"},
{"shift":"9","date":"05/01/2016/08/00/00","car":"208","truck":"185","bike":"360","moto":"195"},
{"shift":"10","date":"05/01/2016/17/00/00","car":"150","truck":"290","bike":"315","moto":"280"},
{"shift":"11","date":"06/01/2016/08/00/00","car":"200","truck":"220","bike":"350","moto":"205"},
{"shift":"12","date":"06/01/2016/17/00/00","car":"230","truck":"170","bike":"390","moto":"400"},
];
var testdate1 = 'Mon Jan 04 2016 08:00:00 GMT-0500 (Eastern Standard Time)';
var testdate2 = 'Sat Jan 02 2016 08:00:00 GMT-0500 (Eastern Standard Time)';
lc1 = dc.lineChart("#line1");

var dateFormat = d3.time.format("%d/%m/%Y/%H/%M/%S");
myCSV.forEach(function (d) {
 d.date = dateFormat.parse(d.date);
});

myCSV.forEach(function (d) {
 d['car'] = +d['car'];
});

//console.log(myCSV);

var facts = crossfilter(myCSV);
var dateDim = facts.dimension(function (d) {return d.date});

var carDim = facts.dimension(function (d) {return d['car']});
var dgCar = dateDim.group().reduceSum(function (d) {return d['car']});

var minDate = new Date ("2016-01-01T08:00:00.000Z");
var maxDate = new Date ("2016-01-06T17:00:00.000Z"); 

var maxY = d3.max(myCSV, function(d) {return d['car']});

lc1
.renderArea(false)
.width(chartWidth)
.height(250)
.dimension(dateDim)
.group(dgCar)
.defined(function(d) {if(d.y !==null) {return d.y;}})
.transitionDuration(1000)
.margins({top: 30, right: 20, bottom: 35, left: 60})
.yAxisLabel('Cars')
.renderHorizontalGridLines(true)
.brushOn(false)
.x(d3.time.scale().domain([minDate,maxDate]));
lc1.yAxis().ticks(5);
lc1.xAxis().ticks(3);

lc1.on('renderlet', function(lc1) {
console.log('myCSV.length: '+myCSV.length);
   var allDots1 = lc1.selectAll('circle.dot');
   //allDots1.filter((d,i) => i != testdate1).classed('pinkdot',true);
   allDots1.filter((d,i) => i === testdate1).classed('greendot',true);
   allDots1.filter(function(d){ return d.x===testdate2 }).classed('reddot',true);
   allDots1.filter(function(d){ if (d.x===testdate2) console.log('Found it') });
   allDots1.filter(function(d){ var xyz = d.x; console.dir(typeof xyz) });
   allDots1.filter((d, k) => console.log("\r\n["+d.x+"]\r\n["+testdate1+"]") );

});//END lc1.on(renderlet)

dc.renderAll();
dc.redrawAll();

function clearconsole(){
console.API;
if (typeof console._commandLineAPI !== 'undefined') {
    console.API = console._commandLineAPI; //chrome
} else if (typeof console._inspectorCommandLineAPI !== 'undefined') {
    console.API = console._inspectorCommandLineAPI; //Safari
} else if (typeof console.clear !== 'undefined') {
    console.API = console;
}
console.API.clear();
}
svg{height:280px;width:500px;}
.greendot{stroke:green !important; fill:green !important; fill-opacity:1 !important;} 
.reddot{stroke:red !important; fill:red !important; fill-opacity:1 !important;}
.pinkdot{stroke:pink; fill:pink; fill-opacity:1 !important;}
<script src="http://cdnjs.cloudflare.com/ajax/libs/d3/3.3.3/d3.min.js"></script>
<script src="http://cdnjs.cloudflare.com/ajax/libs/crossfilter/1.3.1/crossfilter.min.js"></script>
<script src="http://dc-js.github.io/dc.js/js/dc.js"></script>
<link href="http://dc-js.github.io/dc.js/css/dc.css" rel="stylesheet"/>

<svg id="line1"></svg>

2个回答

4

比较日期时,使用getTime()方法,例如:

allDots1.filter(function(d){ 
    console.log(d.data.value, d.x, +d.x, testdate2, d.x===testdate2, +d.x===testdate2); 
    return +d.x===testdate2; // + is a shortcut for .getTime() 
  }).classed('reddot',true);

此外,您应该设置时区的偏移。
var myCSV = [   
  {"shift":"1","date":"01/01/2016/08/00/00/+0500","car":"178","truck":"125","bike":"317","moto":"237"},
  {"shift":"2","date":"01/01/2016/17/00/00/+0500","car":"125","truck":"189","bike":"125","moto":"273"},
  {"shift":"3","date":"02/01/2016/08/00/00/-0500","car":"140","truck":"219","bike":"328","moto":"1252"},
  //...
];

//...

var dateFormat = d3.time.format("%d/%m/%Y/%H/%M/%S/%Z");

演示

参考资料1:日期比较

参考资料2:Javascript中的'+'一元运算符

参考资料3:D3 v3时间格式化


谢谢 - 很棒的答案。问题:在您使用一元运算符将其转换为日期之前,d.xtypeof 是什么? - crashwap
1
d.x 是一个 Date Object,但 typeof 返回的是 object MDN ref,但是有其他方法可以检查一个对象是否为 Date object,例如这些方法 - davcs86
我建议使用 lodash https://lodash.com/docs/4.17.4#isDate。 - davcs86
1
注意 - 我每天都在发现你在回答中放置的新彩蛋。如果有一种方法可以进一步点赞你的回答,我会这样做。感谢您在jsFiddle演示中包含/演示第一个/最后一个日期范围技巧。 - crashwap

3

testdatetestdate2在进行相等性检查时仍然是字符串。尝试使用原始的new Date()或d3的日期/时间函数进行解析:

.filter(function(d){ return d.x >= new Date(testdate2); })

请注意检查JS日期格式返回的时区 - 即使两个值都作为有效的JS日期返回,如果一个在不同的时区中,它们可能不相等。


网页内容由stack overflow 提供, 点击上面的
可以查看英文原文,
原文链接