I've been experimenting with QLV and have worked with 2 synthetic datasets linked by DATE field but with different length of the DATE dimension.
Date in Table 1 spans 1 week, date in Table 2 spans 4 days within the week. Say one table has been more recently updated.
Now I want to graph Sum (Var1) and Sum (Var2) for a period of say, 3 days from the latest COMMON date in Table 1 and Table 2.
Date Var1a ... Var2a
10 100 20
11 90 30
12 98 17
13 101 25
So what I want is the Sum of (Var1a) and (Var2a) between date 13 (latest common occurrence) and date 11. Ideally, letting the user specify whether it's the last 3, 5 or whatever dates.
Any views? Tried this simple thing to work and been hopeless.