Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Currently I have a Straight Table that outputs 2 columns Date and Sum_visitor using the following:
1. Dimension = date
2. Expression (Sum_visitor) = aggr(sum(count_visitor), date)
I also created anothe expression (Sum_visitor_prev_day) to do the same aggregate for number of visitors from the previous date with this expression:
3. Expression (Sum_visitor_prev_day) = aggr(rangesum(above(sum(count_visitor),1,1)), date)
Also, I did 3 loads to get the data
a. First load: May 1
b. Second load: May 2
c. Third load: May 3-May 5
I used incremental qvd to do this and concatenate everything in a cumulative QVD and load cumulative QVD into the main QVW to get the data below.
I kept getting weird values for the 1st and 2nd rows in red below - the correct values that i want are in brackets. Please help!
Thanks,
Erin
Date | Sum_visitor | Sum_visitor_prev_day |
---|---|---|
May 1 | 20 | 25 (0) |
May 2 | 23 | 0 (20) |
May 3 | 17 | 23 |
May 4 | 19 | 17 |
May 5 | 25 | 19 |
Ok I marked this as "assumed answer" by accident. Could someone show me how to undo that please?
Thanks,
Erin