Calendar table

[Saryk]

Hello,

I have data that is timestamped. I figured I'd add a calendar table to manage rolling "last 3 months" analyses for each date.

The tables are linked, but the data is not filled like I would expect it to be. Date is the common field, "Mois" and "Semaine" are Month and Week respectively, from the calendar table ; and "Compte Tous" is a column to count that is the most nondescript for demonstration purposes, my data is otherwise confidential.

I'd like a date in every row there is data, and a month and week value I can sort by for graphs ; should I revert to having everything in one single table ?

[Saryk]

This is what I'd like to have ; here I removed the Calendar table and added the fields directly to the Data table.

[JordyWegman]

Hi Saryk,

You can use these functions for getting the month and week.

    Date(Date#(Date,'DD/MM/YYYY'),'MMM')  as Month,
    Week(Date#(Date,'DD/MM/YYYY'))	   as Week,

How does your data model look? And did you change the Date field with a function? Because it looks like it's not relating very well.

Jordy

Climber 

[Saryk]

I know that, since I have them formatted as such ; I'm saying that when my data model looks like this :

My data in itself is this :

---

When I revert to this : 

My data is properly shown as :

I fail to see the point of a calendar if it doesn't fill the data properly...

[Saryk]

This is my non-functioning calendar table.

It's a shame there is no edit option on this site ; I dislike posting multiple answers to add information to a topic 😕

[JordyWegman]

Hi Saryk,

You can change your answer or post by clicking on the three dots on the right top of your post 😉

Can you remove all the data from your data model that is confidential, keep two confidential  and scramble the fields that are creating the problem and then post the QVF? I have an idea, but it's hard to test here.

Jordy

Climber

[Saryk]

I have no such option to edit ; probably since I'm new here.

Anyway, I'll do that and come back with the qvf asap.

[JordyWegman]

Hmm.. that is strange. But we'll have a look at your QVF when you're ready.

Jordy

Climber

[Saryk]

Here are the files for testing.

[Saryk]

Thank you for taking the time to help by the way 🙂