I could not see the files from the dropbox. But still if you getting blank X-axis, this calcualtion might help you.
You can try this calculation for your X-axis Data
topTwelveData = ExecuteSQL(
""; ¶) ;
RightValues ( topTwelveData ; 12 )
FileMaker 11 Certified Developer
Here is the path again. I am new to Dropbox and not sure if I have all the setting correct. I make an adjustment to dropbox and here is the link.
I was able to download the Filemaker Database from my wife's computer who has a separate account so it should now work.
I am dealing with a large number of records. This example contains 40,000 records. I seek to get a reasonable amount of labels that are not overlapping.
I tried the above solution and it didn't produce acceptable results. I got a solid bar of data displayed.
If you still have issue with data display on x-axis, you might use the label angle setting on the chart options. This screenshot might help you.
Thank you for your suggestions. For some cases it works well.
I contacted Filemaker Tech support and was told that the x-axis, like the y-axis, will calculate it's own values. Conflicts arise when we (as end users) try to overide the built in filtering in using a calcuation for the x-axis. Both end up being applied with unexpected results as demonstrated in the above example. It would have been better if Filemaker gave us the option of applying our own filter if we are not satisified with their selection especially since they gave us the capacity to do it with the calculation option in defining labels. But my assumption but was wrong.
However, I pointed out to the filemaker tech that the algorithm for the Line chart is different from the Scatter and bubble chart. The scatter and Bubble charts do produce acceptable results when I rotate the x-axis labels that are long (such as time display). However, the Line chart doesn't make the same selection. the Tech rep said that they will investigate and possibly correct this discrepancy so that the line chart selection has the same selection as the Bubble and Scatter chart which does produce acceptable scaling.
Thanks Ed for sharing this info.
I found a work around for this issue. I created two charts The "Back" chart contains all the data and labels that I want to display using Line type. However, I do not display any x values on the line plot. I display a " " (space) in the TItle and Data fields.
Then I created a "Front" chart that is overlayed onto the "Back" Chart of type Scatter. I only specify the x-axis values and define the backgound at transparent. I resize the front chart to fit & display just the x-axis. Once it's set right the two charts gives the ilusion of being just one plot but with a workable x-axis scale.
A bit cludgy but it works.