Data per date and hour

[wOOLRITCH]

Hey all,

Thanks for all the support earlier. I have a new problem that i bet is very easy for you to help me with:

The scenario:
I have a small shoe-store and want to view visitors during the day (by hour) and day. As you can see i just puts a sum for each day on one hour... i need it to be distributed over the whole day.

I want to use a measure to get that data. I guess i have to write something linked to FILTER, or CALCUALTE?, but i have tried it in various ways but it still doesnt work. i guess its a really easy fix, please help me out. 🙂 



W 

[stevedep]

I see a lot of arrows going into the date table..

[lbendlin · Accepted solution]

Where does your Hour column come from? It looks like it is mapped to the day of the date.

[wOOLRITCH]

Your comment made me go in and look at the data again. The date and time stamp was generated via a formula in excel (that was my source of data) and it was a small thing in the formula that messed up everything. Big thanks for taking your time.

KR

W

[wOOLRITCH]

Hi, Thanks for looking into it... as you can see on the attached picture it comes from a separate table that i created. (also including a new picture on that one from the data tab).

@lbendlin  Yes, i can see that it looks like it is mapped the day of the date, wich is very weird. The fact table (visitors) is connected via a TimeKey to the separate table for time (as you can see on my first picture). And then i have another table (for date) that is connected to the same fact table... (also seen in the first picture).

@stevedep  Yes, i have many other fact tables connected to the date table as well. KR W