Mixing
Google Charts Datatable filtering on date
I am trying to find all rows for a particular year. The year is a type of string but the cell is type of date.
gDataTable:
business_id date severity
c02facce08ba Dec 13, 2018 Critical
Here is my code thus far:
var yr = 2016,
tl = gDataTable.getFilteredRows([{column: 1, value: yr.toString()}]);
I get the following error:
Uncaught Error: Type mismatch. Value 2016 does not match type date in column index 1
I understand that the value types need to be the same but I can't find a way to filter on just the year of the date column data.
javascript google-visualization
asked Jan 1 at 20:01
MoreScratchMoreScratch
96221235
add a comment |
I am trying to find all rows for a particular year. The year is a type of string but the cell is type of date.
gDataTable:
business_id date severity
c02facce08ba Dec 13, 2018 Critical
Here is my code thus far:
var yr = 2016,
tl = gDataTable.getFilteredRows([{column: 1, value: yr.toString()}]);
I get the following error:
Uncaught Error: Type mismatch. Value 2016 does not match type date in column index 1
I understand that the value types need to be the same but I can't find a way to filter on just the year of the date column data.
javascript google-visualization
asked Jan 1 at 20:01
MoreScratchMoreScratch
96221235
add a comment |
I am trying to find all rows for a particular year. The year is a type of string but the cell is type of date.
gDataTable:
business_id date severity
c02facce08ba Dec 13, 2018 Critical
Here is my code thus far:
var yr = 2016,
tl = gDataTable.getFilteredRows([{column: 1, value: yr.toString()}]);
I get the following error:
Uncaught Error: Type mismatch. Value 2016 does not match type date in column index 1
I understand that the value types need to be the same but I can't find a way to filter on just the year of the date column data.
javascript google-visualization
asked Jan 1 at 20:01
MoreScratchMoreScratch
96221235
I am trying to find all rows for a particular year. The year is a type of string but the cell is type of date.
gDataTable:
business_id date severity
c02facce08ba Dec 13, 2018 Critical
Here is my code thus far:
var yr = 2016,
tl = gDataTable.getFilteredRows([{column: 1, value: yr.toString()}]);
I get the following error:
Uncaught Error: Type mismatch. Value 2016 does not match type date in column index 1
I understand that the value types need to be the same but I can't find a way to filter on just the year of the date column data.
javascript google-visualization
javascript google-visualization
asked Jan 1 at 20:01
MoreScratchMoreScratch
96221235
asked Jan 1 at 20:01
MoreScratchMoreScratch
96221235
asked Jan 1 at 20:01
MoreScratchMoreScratch
96221235
asked Jan 1 at 20:01
MoreScratchMoreScratch
96221235
asked Jan 1 at 20:01
MoreScratchMoreScratch
96221235
96221235
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
instead of providing the value property,
you can use a test function.
the function should return true for the rows that should be included in the filter.
then, just compare the year value of the date.
var yr = 2016;
var tl = gDataTable.getFilteredRows([{
column: 1,
test: function (value) {
return (value.getFullYear() === yr);
}
}]);
answered Jan 1 at 20:21
WhiteHatWhiteHat
37.9k61681
Perfect. Works.
– MoreScratch
Jan 2 at 2:10
add a comment |
Try filtering using minValue and maxValue for the date column:
minD = new Date(yr, 0, 1)
maxD = new Date(yr, 11, 31)
tl = gDataTable.getFilteredRows([{column: 1, minValue: minD, maxValue: maxD}]);
answered Jan 1 at 20:20
user2314737user2314737
15.2k115470
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53998537%2fgoogle-charts-datatable-filtering-on-date%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
instead of providing the value property,
you can use a test function.
the function should return true for the rows that should be included in the filter.
then, just compare the year value of the date.
var yr = 2016;
var tl = gDataTable.getFilteredRows([{
column: 1,
test: function (value) {
return (value.getFullYear() === yr);
}
}]);
answered Jan 1 at 20:21
WhiteHatWhiteHat
37.9k61681
Perfect. Works.
– MoreScratch
Jan 2 at 2:10
add a comment |
instead of providing the value property,
you can use a test function.
the function should return true for the rows that should be included in the filter.
then, just compare the year value of the date.
var yr = 2016;
var tl = gDataTable.getFilteredRows([{
column: 1,
test: function (value) {
return (value.getFullYear() === yr);
}
}]);
answered Jan 1 at 20:21
WhiteHatWhiteHat
37.9k61681
Perfect. Works.
– MoreScratch
Jan 2 at 2:10
add a comment |
instead of providing the value property,
you can use a test function.
the function should return true for the rows that should be included in the filter.
then, just compare the year value of the date.
var yr = 2016;
var tl = gDataTable.getFilteredRows([{
column: 1,
test: function (value) {
return (value.getFullYear() === yr);
}
}]);
answered Jan 1 at 20:21
WhiteHatWhiteHat
37.9k61681
instead of providing the value property,
you can use a test function.
the function should return true for the rows that should be included in the filter.
then, just compare the year value of the date.
var yr = 2016;
var tl = gDataTable.getFilteredRows([{
column: 1,
test: function (value) {
return (value.getFullYear() === yr);
}
}]);
answered Jan 1 at 20:21
WhiteHatWhiteHat
37.9k61681
answered Jan 1 at 20:21
WhiteHatWhiteHat
37.9k61681
answered Jan 1 at 20:21
WhiteHatWhiteHat
37.9k61681
answered Jan 1 at 20:21
WhiteHatWhiteHat
37.9k61681
37.9k61681
Perfect. Works.
– MoreScratch
Jan 2 at 2:10
add a comment |
Perfect. Works.
– MoreScratch
Jan 2 at 2:10
Perfect. Works.
– MoreScratch
Jan 2 at 2:10
Perfect. Works.
– MoreScratch
Jan 2 at 2:10
add a comment |
Try filtering using minValue and maxValue for the date column:
minD = new Date(yr, 0, 1)
maxD = new Date(yr, 11, 31)
tl = gDataTable.getFilteredRows([{column: 1, minValue: minD, maxValue: maxD}]);
answered Jan 1 at 20:20
user2314737user2314737
15.2k115470
add a comment |
Try filtering using minValue and maxValue for the date column:
minD = new Date(yr, 0, 1)
maxD = new Date(yr, 11, 31)
tl = gDataTable.getFilteredRows([{column: 1, minValue: minD, maxValue: maxD}]);
answered Jan 1 at 20:20
user2314737user2314737
15.2k115470
add a comment |
Try filtering using minValue and maxValue for the date column:
minD = new Date(yr, 0, 1)
maxD = new Date(yr, 11, 31)
tl = gDataTable.getFilteredRows([{column: 1, minValue: minD, maxValue: maxD}]);
answered Jan 1 at 20:20
user2314737user2314737
15.2k115470
Try filtering using minValue and maxValue for the date column:
minD = new Date(yr, 0, 1)
maxD = new Date(yr, 11, 31)
tl = gDataTable.getFilteredRows([{column: 1, minValue: minD, maxValue: maxD}]);
answered Jan 1 at 20:20
user2314737user2314737
15.2k115470
answered Jan 1 at 20:20
user2314737user2314737
15.2k115470
answered Jan 1 at 20:20
user2314737user2314737
15.2k115470
answered Jan 1 at 20:20
user2314737user2314737
15.2k115470
15.2k115470
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53998537%2fgoogle-charts-datatable-filtering-on-date%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
