| Author |
 Topic  |
|
|
AKazak
Russia
1205 Posts |
 Posted - 09/01/2024 : 06:15:17 AM
|
OriginPro 2024b (64-bit) 10.1.5.132
Windows 10 Pro for Workstations 10.0.19045.4651
Greetings!
My input data are date-times stored as numerical values.
How do I format columns in a DescStats report to correctly reflect date and time?
Thank you.
---
Andrey |
|
|
YimingChen
1627 Posts |
Posted - 09/03/2024 : 5:03:04 PM
|
I've created jira for this (ORG-29732).
James |
 |
|
|
AKazak
Russia
1205 Posts |
Posted - 09/04/2024 : 04:03:52 AM
|
quote:
Originally posted by YimingChen
I've created jira for this (ORG-29732).
James
Thank you!
I would be happy to test the new feature.
---
Andrey |
|
|
|
minimax
351 Posts |
Posted - 09/04/2024 : 05:09:43 AM
|
Hi Andrey,
The Statistics on Columns tool will generate a normal flat sheet besides the hierarchy report sheet.
On that flat sheet you can easily change the column display format.
Moreover, the flat sheet also shows the group column headers you mentioned in another post.
What is the advantage to use the report sheet in your story? |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 09/04/2024 : 08:15:35 AM
|
quote:
Originally posted by minimax
Hi Andrey,
The Statistics on Columns tool will generate a normal flat sheet besides the hierarchy report sheet.
On that flat sheet you can easily change the column display format.
Moreover, the flat sheet also shows the group column headers you mentioned in another post.
What is the advantage to use the report sheet in your story?
How do I tell Statistics on Columns tool to generate a normal flat sheet besides the hierarchy report sheet?
---
Andrey |
|
|
|
snowli
USA
1397 Posts |
Posted - 09/04/2024 : 08:45:40 AM
|
It's on by default.
In the dialog, go to Output tab, see the Quantities node.
Thanks, Snow
quote:
Originally posted by AKazak
quote:
Originally posted by minimax
Hi Andrey,
The Statistics on Columns tool will generate a normal flat sheet besides the hierarchy report sheet.
On that flat sheet you can easily change the column display format.
Moreover, the flat sheet also shows the group column headers you mentioned in another post.
What is the advantage to use the report sheet in your story?
How do I tell Statistics on Columns tool to generate a normal flat sheet besides the hierarchy report sheet?
---
Andrey
|
|
|
|
AKazak
Russia
1205 Posts |
Posted - 09/04/2024 : 1:55:25 PM
|
quote:
Originally posted by snowli
It's on by default.
In the dialog, go to Output tab, see the Quantities node.
Thanks, Snow
quote:
Originally posted by AKazak
quote:
Originally posted by minimax
Hi Andrey,
The Statistics on Columns tool will generate a normal flat sheet besides the hierarchy report sheet.
On that flat sheet you can easily change the column display format.
Moreover, the flat sheet also shows the group column headers you mentioned in another post.
What is the advantage to use the report sheet in your story?
How do I tell Statistics on Columns tool to generate a normal flat sheet besides the hierarchy report sheet?
---
Andrey
Hm...
Where do I find this resulting flat sheet?
---
Andrey |
|
|
|
snowli
USA
1397 Posts |
Posted - 09/04/2024 : 2:07:15 PM
|
Usually when you do statistics on columns, it generates two sheets in same workbook. One hierarchical sheet "DescStatsOnCols1" and one flat sheet "DescStatsQuantities1"
Thanks, Snow |
|
|
|
minimax
351 Posts |
Posted - 09/04/2024 : 10:01:46 PM
|
Hi Andrey,
In your sample project "2024-09-04.opju" in another post, the flat sheet is "DescStatsQuantities1", on the right side of the "DescStatsOnCols1" report sheet. |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 09/05/2024 : 02:11:49 AM
|
quote:
Originally posted by minimax
Hi Andrey,
In your sample project "2024-09-04.opju" in another post, the flat sheet is "DescStatsQuantities1", on the right side of the "DescStatsOnCols1" report sheet.
I see what you mean now.
You are right: there is no need to set custom formats in this case.
---
Andrey |
|
|
| |
Topic |
|
2024b: format columns in DescStats report