Date Index

[adealboran777]

Hi!

Let's see if somebody can help me. I have a table called "interactions" in which I record the different interactions some employees have with an app and the type of interactions. Also; I have some other tables.

The table "interactions" has a colum called date with the format dd/mm/yy. Also, the other tables have columns with dates. All the columns should be related with a unique date filter so I can present them in a visualization table all together.

To do that, I decided to created a new table with the formula calendar(date(2018;1;1);date(2018;12;31) and make it the key for the relationship and use its column as filter. But it didn't work. Once I filter the dates, all the dates appear in the visualization filter as of 01/01/2018). I mean, if I filter my graphs and tables through the filtering option using the column of the new table, I get that all interactions with the app have been done in 01/01/2018, while I know it is not right.

Does it has to do something with the format?

Thanks in advance!

[tex628]

This sounds like a relationship issue. From what i understand there should be a Many -> One, relationship between interactions & the date table. Make sure that it's a 2-way relationship. 

If it's not an issue with the relationship it's proberbly with how the visualisation is built. You will for example need to use the date column from the date-master table in you visualisations. 

But check the relationship 🙂

/ J

[adealboran777 · Accepted solution]

It didn't solve the problem. It has something to do with the "interactions" table format of the dates (it is an export from my compnay's programmers database).

Finnally I solved the problem making new columns with the following formula and relating them: Year(date)&" - "&Month(date)&" - "&day(date).

Thank you anyway!