Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Overlay variables line chart different datetimes

For a project I want to make a line chart. The lines are displayed next to each other, but they need to be on top of / overlay each other.   Data is imported from a SQL database with the following ...
Need Help
  • mkdejonge's avatar
    mkdejonge
    7 years ago

    Hi Cas,

     

    In the graph your all rows.value is a count of the values.

    See if you can change that to your wanted summarisation in your graph values.

    If that isn't possible change the data type in the query editor for the column.

     

     

    Edit:

    You can extract the minutes or seconds from the field to create a number field:

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Mark,

 

Thank you for you reply. Until the query editor it looks like your solution works perfectly. See the Substraction column:

 

The Data Type is Any. If I leave the Data Type as it is, I get this data after exiting the query editor:

 

If I make a chart I get this:

 

I think Data Type of Substraction should be Time instead of Any, but if I change it to Time I get an error. Do you know how to solve this or if I do something wrong?

 

Thank you and regards,

Cas

mkdejonge's avatar
mkdejonge
Frequent Visitor
7 years ago

Hi Cas,

 

In the graph your all rows.value is a count of the values.

See if you can change that to your wanted summarisation in your graph values.

If that isn't possible change the data type in the query editor for the column.

 

 

Edit:

You can extract the minutes or seconds from the field to create a number field:

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Mark, thank you for your help!