Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to conect a data segment filter with a custom table

Hi 

In my project I have three measures, the first one is a custom date, the second one is the same day but from the past month and the third one is the same day but from the past year. The first date measure is set to take the value of another table wich contains a traditional calendar, the selection is made by a data segmentation filter in the canvas. 

Until this point everything works well but I have to use the values of the three dates explained before to filter the data of another table, to create a resume table that allow me to present the data at the choosed date and the other two periods for comparison, but I can't get the correct definition for the last resume table. I think it is a problem of the date selected through a data segmentation filter.

 

I show a basic diagram of what I need to do: