Calculating hours from days

[dries_clairhout]

Dear Users I have this graphic:

This i number of orders per day.

But I need this per hour.

Any suggestions are welcome!

[YoussefBelloum]

Hi,

how your numbers are coming ? by hours or by days ?

[dries_clairhout]

Hello,

There is a measure (CRE-TIME)

this expresses when the order came in, but in seconds not hours.

[YoussefBelloum]

you're maybe talking about a timestamp ? because if it is coming only in second you will not be able to create a chart with DAYS as dimension.

would you be able to attach sample data ?

[dries_clairhout]

this is an example for another table,

I didn't setup this qlik sense.

But this is how they get to hours.

The "CRE-TIME" is something that sits in different tables.

If I just copy this in the other app,

will this work?

[YoussefBelloum]

the above is specific to CRE-TIME format, it will work if your field is in the same format as the format of CRE-TIME field..

your existing field contain days informations and maybe it is formatted on the script to get only the days.

we need to know what is the source format of your field