Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting graphs

Hi again,

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?

Cheers,

24 Replies
Not applicable
Author

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) ?

rustyfishbones
Master II

you could add a where statement at the end of the script

like this maybe

2013-11-29_1434.png

Not applicable
Author

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)

rustyfishbones
Master II

ok no problem

Not applicable
Author

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).