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.

@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…

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 hea…

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 …

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

My pleasure to help, feel free to put more questions if you need help, here or via personal message!

@ThinhDinh if you like I can show you the app I am working on in Glide it’s really cool and uses data I am gathering from another application and builds a back end around it. I would love your feedback on how I can make it even better.

Adding time variable to graphs

Feature Requests

ThinhDinh May 30, 2020, 1:32am 12

Related to the use of date to filter a chart, if you’re interested.

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

Adding time variable to graphs

Related topics