Mixing
DataStudio chart last day not included (YYYYMMDDHH)
In DataStudio, when using YYYYMMDDHH format for time dimension (from a timestamp field), the last day of the selected date filter is not included. I've tried to set the timestamp format both in the datasource and in the chart properties.
In the example, data for Sept 4th is not included.
Example (format YYYYMMDDHH)
The data source is BigQuery (working fine in BQ console), standard SQL:
SELECT RTU,
DATETIME(fechahora, 'Europe/Madrid') fechahora,
EstadoSensor_Nivel01
FROM TEST.EstadoSensor
WHERE EstadoSensor_Nivel01 > 0
ORDER BY RTU, fechahora
Datastudio Report design
However, if I change the timestamp format to YYYYMMDD it work as expected, and data for the last day in the date range (Sept 4th) is included.
Example (format YYYYMMDD)
Any idea to get the chart with the hours from the last day included? Of course, I could select one day more in the range, but in that case it always includes the last day without data (users might think there are no data for the last day and it is not true)
google-data-studio
asked Nov 21 '18 at 6:28
Juan PeraltaJuan Peralta
11
add a comment |
In DataStudio, when using YYYYMMDDHH format for time dimension (from a timestamp field), the last day of the selected date filter is not included. I've tried to set the timestamp format both in the datasource and in the chart properties.
In the example, data for Sept 4th is not included.
Example (format YYYYMMDDHH)
The data source is BigQuery (working fine in BQ console), standard SQL:
SELECT RTU,
DATETIME(fechahora, 'Europe/Madrid') fechahora,
EstadoSensor_Nivel01
FROM TEST.EstadoSensor
WHERE EstadoSensor_Nivel01 > 0
ORDER BY RTU, fechahora
Datastudio Report design
However, if I change the timestamp format to YYYYMMDD it work as expected, and data for the last day in the date range (Sept 4th) is included.
Example (format YYYYMMDD)
Any idea to get the chart with the hours from the last day included? Of course, I could select one day more in the range, but in that case it always includes the last day without data (users might think there are no data for the last day and it is not true)
google-data-studio
asked Nov 21 '18 at 6:28
Juan PeraltaJuan Peralta
11
What is your data source? If it's BigQuery, have you looked at the query it runs? I'm just wondering if it's a "BETWEEN" query that's missing any hours after '0'?
– Bobbylank
Nov 22 '18 at 10:06
I've just checked one of my reports and its fine, includes the last day and all hours. Can you share a picture of your report set-up (removing anything sensitive)?
– Bobbylank
Nov 22 '18 at 10:10
@Bobbylank: I've edited above, to include the SQL (no BETWEEN operator in it) and the report design. Please, let me know anything else you may need
– Juan Peralta
Nov 23 '18 at 18:27
Doesn't look like anything that would contribute in that. The only other thing I could thing is if your data/default settings are in a different timezones? If not, I'm stumped
– Bobbylank
Nov 26 '18 at 9:32
add a comment |
In DataStudio, when using YYYYMMDDHH format for time dimension (from a timestamp field), the last day of the selected date filter is not included. I've tried to set the timestamp format both in the datasource and in the chart properties.
In the example, data for Sept 4th is not included.
Example (format YYYYMMDDHH)
The data source is BigQuery (working fine in BQ console), standard SQL:
SELECT RTU,
DATETIME(fechahora, 'Europe/Madrid') fechahora,
EstadoSensor_Nivel01
FROM TEST.EstadoSensor
WHERE EstadoSensor_Nivel01 > 0
ORDER BY RTU, fechahora
Datastudio Report design
However, if I change the timestamp format to YYYYMMDD it work as expected, and data for the last day in the date range (Sept 4th) is included.
Example (format YYYYMMDD)
Any idea to get the chart with the hours from the last day included? Of course, I could select one day more in the range, but in that case it always includes the last day without data (users might think there are no data for the last day and it is not true)
google-data-studio
asked Nov 21 '18 at 6:28
Juan PeraltaJuan Peralta
11
In DataStudio, when using YYYYMMDDHH format for time dimension (from a timestamp field), the last day of the selected date filter is not included. I've tried to set the timestamp format both in the datasource and in the chart properties.
In the example, data for Sept 4th is not included.
Example (format YYYYMMDDHH)
The data source is BigQuery (working fine in BQ console), standard SQL:
SELECT RTU,
DATETIME(fechahora, 'Europe/Madrid') fechahora,
EstadoSensor_Nivel01
FROM TEST.EstadoSensor
WHERE EstadoSensor_Nivel01 > 0
ORDER BY RTU, fechahora
Datastudio Report design
However, if I change the timestamp format to YYYYMMDD it work as expected, and data for the last day in the date range (Sept 4th) is included.
Example (format YYYYMMDD)
Any idea to get the chart with the hours from the last day included? Of course, I could select one day more in the range, but in that case it always includes the last day without data (users might think there are no data for the last day and it is not true)
google-data-studio
google-data-studio
asked Nov 21 '18 at 6:28
Juan PeraltaJuan Peralta
11
asked Nov 21 '18 at 6:28
Juan PeraltaJuan Peralta
11
edited Nov 23 '18 at 18:25
Juan Peralta
asked Nov 21 '18 at 6:28
Juan PeraltaJuan Peralta
11
asked Nov 21 '18 at 6:28
Juan PeraltaJuan Peralta
11
asked Nov 21 '18 at 6:28
Juan PeraltaJuan Peralta
11
11
What is your data source? If it's BigQuery, have you looked at the query it runs? I'm just wondering if it's a "BETWEEN" query that's missing any hours after '0'?
– Bobbylank
Nov 22 '18 at 10:06
I've just checked one of my reports and its fine, includes the last day and all hours. Can you share a picture of your report set-up (removing anything sensitive)?
– Bobbylank
Nov 22 '18 at 10:10
@Bobbylank: I've edited above, to include the SQL (no BETWEEN operator in it) and the report design. Please, let me know anything else you may need
– Juan Peralta
Nov 23 '18 at 18:27
Doesn't look like anything that would contribute in that. The only other thing I could thing is if your data/default settings are in a different timezones? If not, I'm stumped
– Bobbylank
Nov 26 '18 at 9:32
add a comment |
What is your data source? If it's BigQuery, have you looked at the query it runs? I'm just wondering if it's a "BETWEEN" query that's missing any hours after '0'?
– Bobbylank
Nov 22 '18 at 10:06
I've just checked one of my reports and its fine, includes the last day and all hours. Can you share a picture of your report set-up (removing anything sensitive)?
– Bobbylank
Nov 22 '18 at 10:10
@Bobbylank: I've edited above, to include the SQL (no BETWEEN operator in it) and the report design. Please, let me know anything else you may need
– Juan Peralta
Nov 23 '18 at 18:27
Doesn't look like anything that would contribute in that. The only other thing I could thing is if your data/default settings are in a different timezones? If not, I'm stumped
– Bobbylank
Nov 26 '18 at 9:32
What is your data source? If it's BigQuery, have you looked at the query it runs? I'm just wondering if it's a "BETWEEN" query that's missing any hours after '0'?
– Bobbylank
Nov 22 '18 at 10:06
What is your data source? If it's BigQuery, have you looked at the query it runs? I'm just wondering if it's a "BETWEEN" query that's missing any hours after '0'?
– Bobbylank
Nov 22 '18 at 10:06
I've just checked one of my reports and its fine, includes the last day and all hours. Can you share a picture of your report set-up (removing anything sensitive)?
– Bobbylank
Nov 22 '18 at 10:10
I've just checked one of my reports and its fine, includes the last day and all hours. Can you share a picture of your report set-up (removing anything sensitive)?
– Bobbylank
Nov 22 '18 at 10:10
@Bobbylank: I've edited above, to include the SQL (no BETWEEN operator in it) and the report design. Please, let me know anything else you may need
– Juan Peralta
Nov 23 '18 at 18:27
@Bobbylank: I've edited above, to include the SQL (no BETWEEN operator in it) and the report design. Please, let me know anything else you may need
– Juan Peralta
Nov 23 '18 at 18:27
Doesn't look like anything that would contribute in that. The only other thing I could thing is if your data/default settings are in a different timezones? If not, I'm stumped
– Bobbylank
Nov 26 '18 at 9:32
Doesn't look like anything that would contribute in that. The only other thing I could thing is if your data/default settings are in a different timezones? If not, I'm stumped
– Bobbylank
Nov 26 '18 at 9:32
add a comment |
0
active
oldest
votes
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%2f53406370%2fdatastudio-chart-last-day-not-included-yyyymmddhh%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53406370%2fdatastudio-chart-last-day-not-included-yyyymmddhh%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
What is your data source? If it's BigQuery, have you looked at the query it runs? I'm just wondering if it's a "BETWEEN" query that's missing any hours after '0'?
– Bobbylank
Nov 22 '18 at 10:06
I've just checked one of my reports and its fine, includes the last day and all hours. Can you share a picture of your report set-up (removing anything sensitive)?
– Bobbylank
Nov 22 '18 at 10:10
@Bobbylank: I've edited above, to include the SQL (no BETWEEN operator in it) and the report design. Please, let me know anything else you may need
– Juan Peralta
Nov 23 '18 at 18:27
Doesn't look like anything that would contribute in that. The only other thing I could thing is if your data/default settings are in a different timezones? If not, I'm stumped
– Bobbylank
Nov 26 '18 at 9:32