Graphing Data

PROBLEM 1

Is there a way, then graphing data from a sheet to have it automatically pull in the data into a graph when new rows are added?

Currently, I click the graph widget on the Dashboard, and select the data I want to graph - but when new rows are added, the data does not automatically get added into the graph -

Thoughts?

Problem 2

I have a data set - that i want to graph data over time - and I want to display multiple lines - based on ONE Column (thats a drop down with different values) - am am trying to graph a line based on the value in the drop down column over time - But what Im getting is the data point from the average column.

Example -

Column A (Date)

Column B (Item Number)

Column C (Average of other data in the row)

Need to graph (Item Number, based on the average, over time)

I would love to do this without creating a graph for each (item number) - but right now, I cant get that to work. Its only giving me the date and average (of that date) without graphing a new line for each item number.

In other graphs ive created, the legend allows to turn on / off specific lines of data - but I cant get this to work here.

Find more posts tagged with

Accepted answers

Genevieve P.

Hi Brian,

For Problem 1, what about using a Report to gather the information for a chart instead of selecting it from a sheet? Reports are selected in their entirety, so as new information populates the sheet (and then Report) it will automatically pull through to the chart. (See here)

For Problem 2, would you be able to provide a screen capture of how your sheet or report is set up?

From what it sounds like, you want the Date to be the X-axis and the values mapped are what's called the Item number (this would be the legend), is that correct?

Here's what I'm picturing:

Screen Shot 2020-06-29 at 7.11.21 AM.png

If this is what you want to see, you'll need each Item to have its own column - this is how it will appear as individual legend values:

Screen Shot 2020-06-29 at 7.11.27 AM.png

If your sheet isn't formatted this way, you could potentially set up another sheet that will use formulas to gather this information & organize it as needed. Let me know if I've misunderstood and I'd be happy to look at your set up to see if what you're looking for is possible!

Cheers,

Genevieve

All comments

Genevieve P.

Hi Brian,

For Problem 2, would you be able to provide a screen capture of how your sheet or report is set up?

From what it sounds like, you want the Date to be the X-axis and the values mapped are what's called the Item number (this would be the legend), is that correct?

Here's what I'm picturing:

If this is what you want to see, you'll need each Item to have its own column - this is how it will appear as individual legend values:

Cheers,

Genevieve

Brian_Anderson_Vegas

@Genevieve P - am I able to graph off a report? - I thought I was limited to graphing from a Sheet??? -

thats a great Idea!

Here is what I need to Graph -

I would like to be able to Graph the BAR ID - (like the items above in your example) and track the signal average as it changes over time.

Right now, all data is in one sheet - I can use automatic move row to separate the data by production line easy enough - but I still cant seem to get BAR IDs to graph as separate lines(like your example above)

This data is captured in form entry - so adding lots of columns for each BAR ID 1-100 would be a pain in the butt for building, and data collection in forms -

Thoughts?

Genevieve P.

Hi @Brian_Anderson_Vegas

Yes! Charts can be built from Reports - makes it easy to gather the information needed...just remember the entire Report is selected (you can't only choose specific cells) so ensure your criteria is super specific.

In regards to your data, to map 3 items like this (Avg number, over time, per item) you would need to have each Bar ID be a column... that's how it will be recognized as an item in the legend, or its own separate line. With your Bar IDs in one column, it will only be able to have the Date as the X axis, then the Signal Average showing over time, but without specifying what each number is related to.

You could potentially create multiple graphs, one-per-BarID. You could create individual Reports with the criteria as the BarID, and then the two columns showing in the Report be the Date & Average:

Screen Shot 2020-07-02 at 11.36.23 AM.png

Then you can compare them side-by-side, it just wouldn't be in the same chart.

If you have access to it, on of our Premium Apps, the Pivot app, would make this easier as it can gather the data from your master sheet and format a second sheet automatically into those columns in my previous suggestion.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.