I am not sure if this is possible yet but I want to add a chart that shows data for the last 30 days vs the lifetime of the info. Is there a way to make the data time-sensitive.

Hi Gera, As of now I don’t think this is doable just inside Glide, but here’s a workaround. I have some random data like column A and B, then in column C I put this in the first cell. ={"Date type";ARRAYFORMULA(IF(A2:A<>"",IF(A2:A>=TODAY()-30,"Within 30 days","Not in last 30 days"),""))} It would result in something like this. [image] Then you can make a chart with it, with the lifetime total value showed in the center. [image] Hope it helps.

[image] ThinhDinh: ={"Date type";ARRAYFORMULA(IF(A2:A<>"",IF(A2:A>=TODAY()-30,"Within 30 days","Not in last 30 days"),""))} You are the MAN! This is super helpful. For some reason, I am getting #REF! Error though. Am I stuck writing a complex formula for this or can I break it out a bit? Here is the end game: Reviews Today Reviews Yesterday Reviews Over The Last 7 days Reviews Over The Last 14 days Reviews Over The Last 30 days Reviews This Month Reviews Last Month Reviews in 2020 Reviews in 2019

@ThinhDinh Update: I got the formula working for some reason though when I turn it into a chat it gives me some bogus numbers. It works in pie chart mode. If I wanted to add a bunch of my variables how would I edit your original formula? By the way you are a boss and this was super helpful.

How many variables do you want to add? It would be complex, but it’s doable if we get the right logic.

Currently, I am looking at 9. Here is how far I have gotten it. ={“Date type”;ARRAYFORMULA(IF( E2:E<>"", E2:E<>"",IF(E2:E>=TODAY()-30, ,IF(E2:E>=TODAY()-7, “Within 7 days”,“Within 30 days”,“Not in last 30 days”,“Not in last 7 days”) ,""))} What is " E2:E<>" doing?

That is part 3.3 in my writeup here. [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 1/ Definition Arrayformula is defined as “a range, mathematical expression using one cell range …

Hi Gera, based on the variables you have listed out I have made a sheet for you. I think it would be better to divided it into 4 columns: Recent: Yesterday & Today By days: Last 7, 14 and 30 days By month: This month & Last month By year: This year & last year You can view the formulas in the header row of each column. ThinhDinh's Glide Lab Profile Name,Image,Email,🔒Row ID Thịnh Đinh,<a...

looking around to learn some more abouth this feature

Related to the use of date to filter a chart, if you’re interested. [image] How to change the data of a chart according to the selected date? I have information that is classified by date and I want to present the data according to it in a graph to represent the history to the selected day. How can I control that? When I put the component to select a date, doesn’t it link it to the table where the data is? Thank you very much for your support [grafica]

@ThinhDinh You are a data modeling wizard! Thank you for putting the functions together for me.

Adding time variable to graphs

Feature Requests

ThinhDinh May 30, 2020, 1:07am 9

That is part 3.3 in my writeup here.

Topic		Replies	Views
Issue with ARRAYFORMULA Ask for Help	4	242	November 2, 2021
Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help	125	15517	September 9, 2022
Show data from - to Ask for Help	6	423	August 29, 2022
Sales App - Follow-up Dates Filter Ask for Help	4	975	December 14, 2021
Rows in google spreadsheet not increasing Ask for Help	12	352	September 26, 2021

Adding time variable to graphs

Related topics