| T O P I C R E V I E W |
| AKazak |
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 |
| 9 L A T E S T R E P L I E S (Newest First) |
| AKazak |
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 |
| minimax |
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. |
| snowli |
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 |
| AKazak |
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 |
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 |
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 |
| minimax |
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 |
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 |
| YimingChen |
Posted - 09/03/2024 : 5:03:04 PM
I've created jira for this (ORG-29732).
James |
