Does anyone know a simple solution to fit two different line measures with different date dimensions from each other into one graph? I am trying to visualize the cumulative returns (daily for midweek data) with the corresponding Model score (+/- weekly) for a stock.
I thought a simple combo chart will do the work, but because both measures use different dimensions (frequent vs less frequent dates) only either one will be shown correctly. My solution is to reload the less frequent measure (Model score) for the dates for which no model score is available. In this way there would be the same amount of data available for both measures and hopefully this will result in the graph I am looking for.
As this is a brand new territory for me, could someone please help me creating this script if this indeed seems the correct solution?
Thank you for your time.
Sebastian
Summary: Combo chart only supports one dimension for multiple measures. How to fit two different line measures with two different date dimensions into one graph? Dimensions are called "Dates" (daily for midweek data) for returns and "DatesCockpit" (+/- weekly) for Model scores.
This looks indeed very much like the appropriate solution! To be 100% sure, I am going to verify this tomorrow. I am really grateful that you could make some time free to help me out. I'll come back to you tomorrow morning!
Sounds like a plan. Just know that this is going to be very slow because Aggr() function is creating a Cartesian product between the two tables to get the desired output. May be it might make sense to do an interval match in the script to improve performance.
Your suggested solution was indeed the one I was looking for! I have slightly adjusted the original question and title to have a better understanding for other people who might face the same problem.
Performance became indeed much slower. I'm going to have a look into your interval match suggestion to see how I can improve speed. Thanks you once again!
