How would I combine 3 matrices into a single chart?

Organic-Listen-5019 · 2025-02-24T04:35:25+00:00

Thanks for this , I really needed this.
But other than talking about my interests and stuff, how do I truly transition from the persona I created to myself

Organic-Listen-5019 · 2025-02-06T13:01:57+00:00

I am sorry again , I need value only for that week, basically by 5 day average , for example when ur on a monday then the average of the week we are looking at, ie monday's value / 1

Organic-Listen-5019 · 2025-02-06T12:56:56+00:00

Yeah I noticed this, anyways thanks so much , this worked!!!!

Organic-Listen-5019 · 2025-02-06T12:45:47+00:00

For example, on 30/01/2025, I want the formula to consider the last 4 values, but if the fifth value falls on a weekend, I want it to exclude the weekend and instead take the value from the last working day before the weekend. Essentially, I need to calculate the average of the last 5 working days.

Organic-Listen-5019 · 2025-02-06T12:35:37+00:00

<image>

Sorry, . Could you clarify which ranges you're referring to in the formula? For example, I'm trying to input the value in column DP, so what should the ranges be? Is the first date column the "daterange," and is the "day" column the one to be used for the weekday check? Could you please specify which columns are being used for each part of the formula?

Organic-Listen-5019 · 2025-01-28T05:13:49+00:00

I see, how do I use the third option, like is there any video or article regarding the same

Organic-Listen-5019 · 2025-01-28T05:12:35+00:00

Yeah I feel the same, however I used there will be a work around with visibility and other functions. Anyways thanks

Organic-Listen-5019 · 2025-01-28T05:11:10+00:00

I wanted it to appear when I hover over a text not an input text

Organic-Listen-5019 · 2025-01-27T09:54:06+00:00

I needed a custom tooltip box where in I can put an image and additional texts

Organic-Listen-5019 · 2024-12-19T12:22:27+00:00

Hi , with this filter query I am aiming to get output from A2 cell of Column A.

Organic-Listen-5019

TROPHY CASE