How do I set up the data field or fields of time (days, hours, & minutes) for the X axis of a graph that will last months with several data records a day.
My tests haven’t worked.
Are these 3 different fields you have that you want to display on the X-Axis? Days, Hours, and Minutes)?
You can only choose a single field for the X-Axis.
Then you would choose 1 or more fields for the Series. These would be fields that have numeric values that will be used to determine the height of the bar on the chart.
I’ve attached an example where the X-Axis field is Category, the Series field is just “Purchase Price”, and I’ve told it to show the values and show just the group summaries. So the Purchase Price field has a Total calculation set on it and so it shows the total of the Purchase Price for each category on a chart.
I’m not sure how your form is setup, so I just chose this as an example.
Attachments:
You must be
logged in to view attached files.
I can do those graphs. The one I’m having trouble with is with time.
Actually I want the x axis to be a single value which incorporates Year + month + day + hour + min.
The decimel point could be at the day level with hours and minutes the decimal fraction.
Kinda like the European today at 2:30 pm of 202603.1450
The problem is parcing the Date and time resuslt from that click of the button to get that complicated value. I’m guessing I have to do a calculated field to pull out the values from the TF result. I just haven’t had to time to figure out how to do that so hope somebody had already figured it out.
Yes, you can use the DATE() function in a Calculation field to format a date field value to display as you like.
DATE([Some Date Field]; "yyyyMM.HHmm")
That is less work than I was going to do. I looked at those date propterties & descriptions, but I wasn’t exactly sure what they would produce or what they could take.
Thanks.
That worked to get a number for date and time.
It seemed to accept that for a graph on the x axis, but the number I want to graph
is a calculated field – “Number” and the graph won’t accept that. ???
See attached. I added details of those 2 fields to the screenshot.
Attachments:
You must be
logged in to view attached files.
I got rid of the string to date with text output.
The result is the same.
The “Number” field will still not be accepted by the graph.
That format is STR2NUM(LEFT(Cond; 1)) Just to get the number from “Cond” field which is a picklist.
If you email me an archive of your form, then I can take a look at it more closely.
Excuse the use that TF is being used for, but as a irritable bowl sufferer, I would like to know if there is a pattern to swings between diahrrea and constipation. You can forget the previous sentence, ha.
Is your graphing able to plot numbers against values to see correlations, or is the X axis only character based labels?
Here is the tfarc file.
Attachments:
You must be
logged in to view attached files.
Thanks for the file. The X axis does allow you to pick number fields. You can choose one X axis field, but multiple Y axis fields (Series fields). So the X axis would be your Dig Day/Time field. And your series fields could be your Number or other numeric type fields. They have to be numeric because they are plotting a numeric value to dictate the height of each bar.
Attached is an example of your chart.
Attachments:
You must be
logged in to view attached files.
Ys, that is what I want.
How do I do that?
What did you have to change?
I’ve changed both fields back and forth from text to number type and can’t get it right.
I just chose your Dig day/time field for X-Axis and then your Number field for Series field. I also turned OFF the show group summaries checkbox.
Nothing I do will led me select “Series” = Field “Number”.
Nothing shows up on the graph.
Send back the tfac file so I can see it work here??
TF 5 Version 5.3.45 (Build 1075)
I see right away what I was doing wrong.
I didn’t know there was a check box left of “Number” that had to be checked for it to be saved for the graph.That is a very light shade of grey (so light and non contrasting against the white of the background) that I didn’t know it was there.
Putting a box around that light grey square would make it obvious. I can’t tell you how many hours I’ve wasted on that little thing.Anyway, thanks, I’m on the road now.
BTW, instructions for graphing???
Regarding the above graph, I notice all the x values are treated as a label of “number”.
Is there a way to get the ordinal day listed as the variable it is as a major mark.
Or, is the x axis only capable of labels.
It would be nice to see the start and end of each day. I thought the “Date” variable would do that. Or, do I have to export it into a spreadsheet to graph it?
The Series fields will display the numeric values that dictate the height of each bar. The X-axis label is just the text that appears below the bars.
.
