I have two questions regarding how to structure and format numbers in a graph. I am using a Line Chart for this.
1. The graph i have is filled with 0 values. That makes it look very "skippy" with the graph jumping up an down. Is there a way to smooth this graph out? I know there is a function under the Expression Tab to use the trend lines, but I dont think this gives a good enough representation.
2. I would like to input a line marking the 1200 point. This would be a vertical, static line at 1200 running through the graph. Any ideas?
probably an data error - its not a wanted thing, however it may happened again. is there a way to input a function that screens for this? ie; IF(received_date >> TODAY(), do not count) ?
i still have the problem with the grouped graphs when checking continuous ... how do i change this?
is there a way for me to make a selection directly instead? lets say i wanted the graph to only show dates from today and 200 days back? i think this may change it? (ill start a new thread since this is kinda side-tracking)
i have a feeling i can get around this by simply restricting the user to see all data (the idea really isnt that all this data is suppose to be there anyhow, and i assume its a lot of bad data spooking around here).
