About Aylas

Aylas · 12-11-2021

How to cut the continuity of the line in a graph if the value is equal to zero or equal to empty? this is how the graph looks with zero values or empty values this is how i want it to be visualized thank you very much for your contributions

Aylas · 11-29-2021

Good morning, I have a table with multiple records, from which I want to retrieve the last N records, these in turn must belong to the same point. IdReg__|Cod.Punto|pH__|Od|NTU … 2210|PTO001__|7.45|5.41|12.1 2211|PTO002_|8.15|7.97|7.88 2212|PTO003_|7...

Aylas · 12-11-2021

me sirvió esta sentencia IN([_THISROW], TOP( ORDERBY( FILTER(“Registro MT”, AND( [Cod. Estación]=“EM-521”, [Ph]<>Number("") ) ), [_ROWNUMBER],true) ,20 ) ) En la tabla google Sheet la celda de pH esta vacía por eso uso Number("") y si en tu caso esta...

Aylas · 12-11-2021

gracias por la innovación, ¿hay alguna manera de que los valores “0” o los valores vacíos no se grafican?

Aylas · 12-11-2021

I have the same problem, any solution?

Aylas · 11-29-2021

Perfect, thank you very much, it worked like a charm.

Aylas · 11-29-2021

Thank you very much, for your consideration, I attach some screenshots, I did not manage to make the sentence run.

My Stats

sizrailev's Bio

Badges Aylas Earned

Recent Activity

Help with graph with zero or empty values

Retrieve last N records from a table

Re: Dashboard Experts! How not to show 0 columns

Re: New Charts in AppSheet applications - in Preview Program

Re: Chart with data of virtual columns sets blank/error values to "0" instead of "blank"

Re: Retrieve last N records from a table

Re: Retrieve last N records from a table