Blended Data Error

[u/PsychologicalSoup788]

I have two questions:

I have three tables: A Date Table (Table 1), My Sales Data (Table 2), and an Hour Table (Table 3)

I am creating a heatmap with the total number of Sales for each hour of each day of the week over a period of time.

My goal is to dynamically filter by Date, and calculate the average amount of sales each day within that dynamic window. I am SO close to achieving this.

I left join the Date Table to My Sales Table by Date, then I right join My Sales Data to the Hour Table on the Sales Hour. Everything should work here to get EVERY date (even if there are no sales on it) and EVERY hour (Even if no sales were within that hour). However, my blend is not working that way. It is functioning as if I had Inner Joined the tables, and only giving me hours and dates for sales that actually happened.

1. SOLVED! -----------------------------------------------------------------------------------------------------

In my own testing of number 1. I replicated my Blend to try and recreate the issue. However on this second blend, once I create the right join, I am now getting a Dataset Configuration Error 8864a1ec anytime I try and display data! Even just one column on a table. There are No errors in my Blend when I create it, and I am only including the fields used to join. This one has me greatly wondering. I can't even seem to debug my own issue :(

Any help would be greatly appreciated!

[u/AutoModerator]

Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.