Hi,I cannot generate a graph for data with 500,000 records. It keeps loading on the admin screen. I want to know if this amount of data is not supported in the first place.sample data↓https://tekika.jp/wp-content/uploads/2024/11/13_Tokyo_manshon.csv

Hi,

I have successfully created a graph with 200,000 rows, but the site has become very slow and unstable.

https://tekika.jp/2024/11/14/20%e4%b8%87%e8%a1%8c%e3%83%86%e3%82%b9%e3%83%88-2/

I am trying to reduce the amount of data, but I really need a solution. I have tried other plugins but they did not work.
Attached is link of Looker. I would like to achieve this.

https://lookerstudio.google.com/u/0/reporting/95990baf-0ff9-49c8-ac62-ca767e08a0aa/page/TlJ0C/edit

I was able to solve the problem on my own!
Tables are created from SQL
Creating them from CSV files makes them heavy
Creating graphs from SQL is faster
Split the file
300,000 rows can be handled
1.8 million rows is difficult to generate graph
Thank you very much!

https://tekika.jp/2024/11/15/%e6%9d%b1%e4%ba%ac30%e4%b8%87%e3%83%ac%e3%82%b3%e3%83%bc%e3%83%89%ef%bc%88%e6%9d%b1%e4%ba%ac%e5%90%ab%e3%82%80%ef%bc%89/

One question.

Is this not a total, or can't the average be aggregated?