Edit Relationship: Problem in granularity

Hi,

Here is my history and my problem:

I'm connecting Hour per Date in online connection with Google Analytics and Hour per Date in Excel file.

First I had to create a calculated field (DATEADD('hour',[StartHour],[Datum] )) to unified Date and Hour in my sources and after, I created a relationship between the Google Analytics and my Excel file using Data+Hour as a linking.

The problem is when I use Date+Hour of the Google Analytics and make a chart with two variables, I can see my sessions correctly but I can't see all channels of my excel file. Tableau shows a " * " (light blue)  as in my first picture.

When I use the Date+Hour of my Excel file, I can see all channels correctly but I can't see all sessions per hour as in my second picture.

My Goal is a dual axis chart showing an area chart of my sessions as in my first picture and circles per channels as in my second picture.

What is the problem here and how can I solve it?

Ps: I can't share this file.

Thank you