Hi!
I am looking to set up a line graph pulled from a Google Sheet which tracks solar production over a monthly basis across multiple sites. Seems super basic but I can’t seem to figure out how to set it up (first-time user!!
My data is setup where the first row shows the month formatted as a date, the first column is the Solar site formatted as a plain text, then the data fills in from B2 - M87 as a number. When I imported my data I ticked Use First Row as Headers and used the specific range.
I have added the months as a dimension in my report and am trying to get a line graph where my solar site (column A) is a line graph with the X axis as the month and Y axis as production with a line for each site that I can then filter from. I cannot seem to get the axis correct, additionally my data is now pulling about 10 decimal places when the data source only has two.
Any help / advice on this would be hugely appreciated!