Your need to do some data prepration first. Use Tableau prep to join and then pivot your data from both data sources to make it easier
Thanks Deepak for consideration.
Can you plzz give an example for your proposed solution ?
I need your data and then can try you may fake something similar to your actual thing..
Can you plzz guide me for another problem Im facing: I have a Date filter for hourly and daily aggregations whereas for weekly aggregation Im making a calculation and using it as a
Start Week Date Filter calculation: date(datetrunc('week',date("1" + "/" + "1" + "/" + STR([Year]))+([Week]-1)*7,'Sunday')) where [Week] and [Year] are the integer values like year = 2018 and week = 21,31 n so on
Im getting correct Date filters for my Hourly,Daily and Weekly aggregations. When I go for Monthly aggregated Data ( and now I have [Month] as integer value in Data) I tried to use Month/Year format from Start of the Week calculation BUT when I show filter; graph is shown against NULL/ALL selected in this Month Date Filter and against valid selected Months in filter I dont get graph. WHY is that so ???? The filter is showing values lik January 2018, February 2018, March 2018. I even tried out using Month/Year format in Relative Date filter type on Start of the Week DATE but same problem persists there as well.
Thanks & Appreciated Depak