admin管理员组

文章数量:1122846

I am trying to automate the creation of charts which display power readings over the last eight quarters for a piece of equipment. I am using a pivot table to filter the raw data before converting it into a chart, but I realize that the table is converting blanks from the raw data into zeros on the chart. This is causing my power readings to look they are dropping to zero, when in fact the equipment was just out of commission or the voltage readings were skipped that quarter.

I would just create a chart and manually filter the data, but I have multiple pieces of equipment with multiple power charts each that I want to be able to see all at once.

Pivot Table Example

Date L1/L2 L1/L3 L2/L3 L1 L2 L3
03/03/2023 0 0 0 0 0 0
05/09/2023 476 478 478 0.31 0.32 0.36
08/08/2023 0 0 0 0.33 0.32 0.22
11/02/2023 487 488 490 0.18 0.22 0.19
02/09/2024 481 482 484 0.35 0.34 0.29
05/14/2024 479 481 479 0.31 0.32 0.36
08/07/2024 479 481 483 0.6 0.6 0.6
11/06/2024 484 484 487 0.2 0.3 0.2

本文标签： chartsHow can I differentiate between 0 values and nullblank values in Google SheetsStack Overflow

版权声明：本文标题：charts - How can I differentiate between 0 values and nullblank values in Google Sheets? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736308613a1933723.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。