Newbies sbell22 Posted April 11, 2016 Newbies Share Posted April 11, 2016 I'm learning Filemaker in order to bring over some of my favorite applications from spreadsheets. My first chart is just to learn how to use charting, I'm taking data I record maybe, six times a month when i weigh in at the Gym to create a line chart. Problem is, if i make it into a bar or line chart the x axis only includes the dates where I entered DATA. It needs to include every day of the past 30 so I can accurately see the trends. The only data *points* will be the data I've entered; it would just connect those dots. Here's a 5-month version (as a bar chart) so you can see the problem. TIA for any assistance! Link to comment Share on other sites More sharing options...
comment Posted April 12, 2016 Share Posted April 12, 2016 (edited) I don't understand your request. You cannot have a chart showing the last 30 days, unless you have (a) a list of the last 30 days, and (b) a corresponding list of 30 values. If you don't have a real value for each one of the last 30 days, you will have to generate some fake values (perhaps by interpolating the existing values?). That's a problem that has nothing to do with charting, and it needs to be solved before you can approach the problem of charting the resulting data (which by then should be trivial). 6 hours ago, sbell22 said: Here's a 5-month version (as a bar chart) so you can see the problem. I am afraid I don't see the relevance. Edited April 12, 2016 by comment Link to comment Share on other sites More sharing options...
Newbies sbell22 Posted April 12, 2016 Author Newbies Share Posted April 12, 2016 (edited) I'm attempting to create a chart over time, with a uniform x (one increment per day) axis. But I haven't logged data for every day, and I don't want to write formulas to interpolate between differently spaced data points, or create artificial data. It's simple to do in Excel or Gsheets, so I thought there might be an equivalent method or chart setting in Filemaker. The relevance of the chart is because it illustrates the problem: I want to plot that data over a six month period, but I only logged data on 10 days between Nov 28 and April 2. Edited April 12, 2016 by sbell22 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3064 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now