[SOLVED] Time as measure (y axis) and day as dimension (x axis)
Hi, My requirement is to have time as measure (y axis) and date as dimension (x axis).
Also how do you take average of time, apart from converting it into seconds.
Any sample is greatly appreciated.
Regards, KRThis message has been edited. Last edited by: rkiran1,
Version 8.2.03 Output : HTML, Excel & PDF
January 30, 2020, 12:20 PM
Waz
A little more information would help.
What is the format of your field(s) ?
What version of WebFOCUS are you on ? You should update your signature
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
January 30, 2020, 03:17 PM
rkiran1
I hope the below details helps.
1 . We have time/duration HHIS in one field and category in another, we have to take average of time for all category.
Bar graph is the desired output with y axis in time/duration and x axis as category.
2. We have date in YYMD format and want to plot against above time.
Finally the user wants the datatext in ##:## format.
Thanks, KR
Version 8.2.03 Output : HTML, Excel & PDF
January 30, 2020, 04:24 PM
Waz
Can you do a mock up with one of the sample files ?, Still not getting what you are doing.
Have you done a search of Focal Point for, say, "HHIS graph" ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
January 31, 2020, 09:50 AM
BabakNYC
Bar charts are the default type in InfoAssist. Select the data you'd like to use and drage the Date field to the Horizontal Axis and the Time field to the Vertical Axis. That should give you a starting point for what you want. Now if you can make styling changes and so on.
WebFOCUS 8206, Unix, Windows
March 30, 2020, 08:41 AM
rkiran1
The below code worked for me. David Briars code from the below link help me solve my issue