Mdthbs

What do mathematicians mean when they say some conjecture can’t be proven using the current technology?

Ethical for a company to ask employees to move furniture on the weekend?

I have accepted an internship offer. Should I inform companies I have applied to that have not gotten back to me yet?

Clarification on defining FFT bin sizes

When does Fisher's "go get more data" approach make sense?

MQTT subscription topic match

What does it mean to fail a saving throw by 5 or more?

Identification of an AC transformer

Using two linked programs, output ordinal numbers up to n

Why are road bikes (not time trial bikes) used in many triathlons?

Could a planet have a naturally occuring moon at one of its Lagrange points?

Is this more than a packing puzzle?

Was Willow's first magic display (blazing arrow through arm) actual magic, and if not, what's the trick?

When to ask for constructive criticism?

Why isn't aluminium involved in biological processes?

pgfkeys: .store in constructed macro

Why run a service as a system user?

Is there a good program to play chess online in ubuntu?

Why hasn't the U.S. government paid war reparations to any country it attacked?

What do these three diagonal lines that cross through three measures and both staves mean, and what are they called?

I do not have power to all my breakers

Why do candidates not quit if they no longer have a realistic chance to win in the 2020 US presidents election

Are the errors in this formulation of the simple linear regression model random variables?

What are the arguments for California’s nonpartisan blanket (jungle) primaries?

Making graphs from database with Time/Date field

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

4

I've been trying to make a diagram from a LibreOffice (version 4.2.8.2) Base database with a date/time field, by copying the table in Calc. But the graph completely ignores the time part.

To explain what I mean, I've made a simple example database with one table. Here's the table definition:

And here's the table content, as defined in Base:

I've then copy/pasted the table into a new Calc document, and generated a graph from the data. The result looks like this:

As you can see, in the copied data, both date and time are still there, but in the diagram, the time is set to 0:00 for all data points, making the diagram wrong.

So what do I have to do to get a correct diagram from my database?

database libreoffice

share|improve this question

asked Aug 20 '15 at 20:36

celtschkceltschk

7,31111 gold badge1313 silver badges2020 bronze badges

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Would whoever downvoted this question please add a comment what's wrong with it?
  
  – celtschk
  Aug 20 '15 at 20:40
  

  
  
  
  

add a comment | 

4

I've been trying to make a diagram from a LibreOffice (version 4.2.8.2) Base database with a date/time field, by copying the table in Calc. But the graph completely ignores the time part.

To explain what I mean, I've made a simple example database with one table. Here's the table definition:

And here's the table content, as defined in Base:

I've then copy/pasted the table into a new Calc document, and generated a graph from the data. The result looks like this:

As you can see, in the copied data, both date and time are still there, but in the diagram, the time is set to 0:00 for all data points, making the diagram wrong.

So what do I have to do to get a correct diagram from my database?

database libreoffice

share|improve this question

asked Aug 20 '15 at 20:36

celtschkceltschk

7,31111 gold badge1313 silver badges2020 bronze badges

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Would whoever downvoted this question please add a comment what's wrong with it?
  
  – celtschk
  Aug 20 '15 at 20:40
  

  
  
  
  

add a comment | 

I've been trying to make a diagram from a LibreOffice (version 4.2.8.2) Base database with a date/time field, by copying the table in Calc. But the graph completely ignores the time part.

To explain what I mean, I've made a simple example database with one table. Here's the table definition:

And here's the table content, as defined in Base:

I've then copy/pasted the table into a new Calc document, and generated a graph from the data. The result looks like this:

As you can see, in the copied data, both date and time are still there, but in the diagram, the time is set to 0:00 for all data points, making the diagram wrong.

So what do I have to do to get a correct diagram from my database?

database libreoffice

share|improve this question

asked Aug 20 '15 at 20:36

celtschkceltschk

7,31111 gold badge1313 silver badges2020 bronze badges

share|improve this question

asked Aug 20 '15 at 20:36

celtschkceltschk

7,31111 gold badge1313 silver badges2020 bronze badges

share|improve this question

asked Aug 20 '15 at 20:36

celtschkceltschk

7,31111 gold badge1313 silver badges2020 bronze badges

asked Aug 20 '15 at 20:36

celtschkceltschk

7,31111 gold badge1313 silver badges2020 bronze badges

asked Aug 20 '15 at 20:36

celtschkceltschk

7,31111 gold badge1313 silver badges2020 bronze badges

2 Answers
2

active

oldest

votes

4

First, check the chart type - is hat to be XY (Scatter). Second, check the content type of the Zeit column. Is it plain text, or are the values recognized as date/time values by LO? To check this, select one of those cells, right-click and select Format Cells... - on the Numbers tab, LO should have selected a date/time format. Now, it should work:

See also this Q/A on creating charts in LO Calc with date (/time) values.

share|improve this answer

edited Mar 20 '17 at 10:04

Community♦

1

answered Aug 21 '15 at 7:15

tohuwawohutohuwawohu

94722 gold badges88 silver badges1717 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you. It was the XY (Scatter) option that I got wrong; I had selected "Line diagram" (or however it is called in the English interface; "Liniendiagramm" in German, located directly above the XY) I now get the correct graph.
  
  – celtschk
  Aug 21 '15 at 17:29
  

  
  
  
  

add a comment | 

0

But where is the time part. time part is not labelled according to the table.

share|improve this answer

answered 58 mins ago

user362498user362498

1

New contributor

user362498 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "106"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});


}
});

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f224508%2fmaking-graphs-from-database-with-time-date-field%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

4

First, check the chart type - is hat to be XY (Scatter). Second, check the content type of the Zeit column. Is it plain text, or are the values recognized as date/time values by LO? To check this, select one of those cells, right-click and select Format Cells... - on the Numbers tab, LO should have selected a date/time format. Now, it should work:

See also this Q/A on creating charts in LO Calc with date (/time) values.

share|improve this answer

edited Mar 20 '17 at 10:04

Community♦

1

answered Aug 21 '15 at 7:15

tohuwawohutohuwawohu

94722 gold badges88 silver badges1717 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you. It was the XY (Scatter) option that I got wrong; I had selected "Line diagram" (or however it is called in the English interface; "Liniendiagramm" in German, located directly above the XY) I now get the correct graph.
  
  – celtschk
  Aug 21 '15 at 17:29
  

  
  
  
  

add a comment | 

4

First, check the chart type - is hat to be XY (Scatter). Second, check the content type of the Zeit column. Is it plain text, or are the values recognized as date/time values by LO? To check this, select one of those cells, right-click and select Format Cells... - on the Numbers tab, LO should have selected a date/time format. Now, it should work:

See also this Q/A on creating charts in LO Calc with date (/time) values.

share|improve this answer

edited Mar 20 '17 at 10:04

Community♦

1

answered Aug 21 '15 at 7:15

tohuwawohutohuwawohu

94722 gold badges88 silver badges1717 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you. It was the XY (Scatter) option that I got wrong; I had selected "Line diagram" (or however it is called in the English interface; "Liniendiagramm" in German, located directly above the XY) I now get the correct graph.
  
  – celtschk
  Aug 21 '15 at 17:29
  

  
  
  
  

add a comment | 

First, check the chart type - is hat to be XY (Scatter). Second, check the content type of the Zeit column. Is it plain text, or are the values recognized as date/time values by LO? To check this, select one of those cells, right-click and select Format Cells... - on the Numbers tab, LO should have selected a date/time format. Now, it should work:

See also this Q/A on creating charts in LO Calc with date (/time) values.

share|improve this answer

edited Mar 20 '17 at 10:04

Community♦

1

answered Aug 21 '15 at 7:15

tohuwawohutohuwawohu

94722 gold badges88 silver badges1717 bronze badges

share|improve this answer

edited Mar 20 '17 at 10:04

Community♦

1

answered Aug 21 '15 at 7:15

tohuwawohutohuwawohu

94722 gold badges88 silver badges1717 bronze badges

edited Mar 20 '17 at 10:04

Community♦

1

edited Mar 20 '17 at 10:04

Community♦

1

answered Aug 21 '15 at 7:15

tohuwawohutohuwawohu

94722 gold badges88 silver badges1717 bronze badges

answered Aug 21 '15 at 7:15

tohuwawohutohuwawohu

94722 gold badges88 silver badges1717 bronze badges

0

But where is the time part. time part is not labelled according to the table.

share|improve this answer

answered 58 mins ago

user362498user362498

1

New contributor

user362498 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

But where is the time part. time part is not labelled according to the table.

share|improve this answer

answered 58 mins ago

user362498user362498

1

New contributor

user362498 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

But where is the time part. time part is not labelled according to the table.

share|improve this answer

answered 58 mins ago

user362498user362498

1

New contributor

user362498 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this answer

answered 58 mins ago

user362498user362498

1

New contributor

user362498 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 58 mins ago

user362498user362498

1

New contributor

user362498 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 58 mins ago

user362498user362498

1