When CSV files are used by the API, it guesses the data type of each column. It's reading the number columns properly but I think it is importing the date as a string and so cannot graph it on a trendline.
From https://developers.google.com/chart/interactive/docs/reference#google.visualization.arraytodatatable you can change the header of the CSV file to {label: 'fecha', type: 'date'},sistolica,diastolica,pulsaciones,saturacion On Monday, May 1, 2023 at 7:59:37 AM UTC-4 José Vicente Zahonero wrote: > Hi, I have modified my HTML-PHP file with your specifications and I still > can't see the lines with the averages. The only difference between your > proposal and mine is the way to create the csv file, I create it from a > Postgres query and you do not. I attach the code I have and a screenshot of > what it returns. Best regards.[image: Captura_001.png] > > El lunes, 1 de mayo de 2023 a las 12:50:00 UTC+2, Ray Thomas escribió: > >> I used a LineChart because Trendlines only work on Scatter Charts, Bar >> Charts, Column Charts, and Line Charts. >> >> Sorry, I should have explained that in my answer. >> >> I also don't have PHP installed so what I did was use a query to open the >> CSV file after I rewrote the dates. The complete code I used is at >> https://brisray.com/test/jose.htm (which is where the screenshot came >> from) and the CSV file is at https://brisray.com/test/jose.csv >> <https://brisray.com/test/jose.csv> >> >> On Monday, May 1, 2023 at 2:12:51 AM UTC-4 José Vicente Zahonero wrote: >> >>> Hi, I have tried changing the format of the dates to 'yyyy-MM-dd' in the >>> csv and I have added the code you have indicated but it doesn't show me any >>> average line in the graph. >>> [image: Captura_001.png] >>> >>> El lunes, 1 de mayo de 2023 a las 1:41:03 UTC+2, Ray Thomas escribió: >>> >>>> The quickest way is to add a trendline to the graph. Add this something >>>> like this under your series statements in the options secion: >>>> >>>> trendlines: { >>>> 0:{type: 'linear', color: 'yellow', visibleInLegend: true, >>>> lineWidth:2}, >>>> 1:{type: 'linear', color: 'yellow', visibleInLegend: true, >>>> lineWidth:2}, >>>> 2:{type: 'linear', color: 'yellow', visibleInLegend: true, >>>> lineWidth:2}, >>>> 3:{type: 'linear', color: 'yellow', visibleInLegend: true, >>>> lineWidth:2} >>>> }, >>>> >>>> Trendlines do not work on discrete data such as strings, so you have to >>>> change your CSV file to the preferred date format which for a CSV file is >>>> yyyy-MM-dd or do it in the datatable. The trendline help is at >>>> https://developers.google.com/chart/interactive/docs/gallery/trendlines >>>> >>>> [image: jose-trendlines.jpg] >>>> >>>> Trendlines are not averages, so if you really need those you need to >>>> create new columns in the datatable and calculate them yourself. The >>>> example in the ComboChart help at >>>> https://developers.google.com/chart/interactive/docs/gallery/combochart >>>> uses the averages of the row data but you need it for the column data. So >>>> you'll need 4 new columns, one for each of the current columns, and each >>>> of >>>> the new columns will contain all the same number, the column averages. >>>> >>>> Another method of getting the averages is to use the aggregation >>>> method. The help for that is at >>>> https://developers.google.com/chart/interactive/docs/reference#data-manipulation-methods. >>>> >>>> Because that depends on grouping the data, you are going to need a new >>>> column containing a single value in all the rows so they can be grouped >>>> together. How to use this properly has come up fairly often so there are >>>> examples on Stack Overflow. Here are some: >>>> >>>> >>>> https://stackoverflow.com/questions/58417507/how-to-draw-an-average-column-in-google-charts-bar-chart >>>> >>>> https://stackoverflow.com/questions/50004379/draw-a-line-to-show-the-average-distribution-in-google-scatter-plot >>>> >>>> https://stackoverflow.com/questions/35918308/average-line-for-current-data-in-a-google-combochart >>>> >>>> I don't know who WhiteHat is, but they certainly know their way around >>>> the API. >>>> >>>> On Saturday, April 29, 2023 at 3:59:39 AM UTC-4 José Vicente Zahonero >>>> wrote: >>>> >>>>> Hi, I have an area chart in which I represent some values taken from a >>>>> csv file. I would like to be able to add the averages corresponding to >>>>> each >>>>> column to the graph, can you help me? >>>>> My code is in the attached file. Thanks for you help. >>>>> >>>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/d106242e-4876-437a-a2eb-499632187230n%40googlegroups.com.
