Hey Guys,
I cant figure out how to create a visual that shows day over day data with a 7 and 14 day volume change on the most recent date. I already created a measure to calculate the 7 and 14 Day difference, but when I put it into the matrix, it does the calc for each date.....
Here's what I want (example)
<tbody>
</tbody>
Here's what I"m getting (example)
<tbody>
</tbody>
* Where it says Volume Diff (6 day) my measure shows up after eachday doing the calc 6 days back ---- But I just want it on the last date..
Hope this makes sense.....Appreciate any help.
Thanks
I cant figure out how to create a visual that shows day over day data with a 7 and 14 day volume change on the most recent date. I already created a measure to calculate the 7 and 14 Day difference, but when I put it into the matrix, it does the calc for each date.....
Here's what I want (example)
Date | 4/1 | 4/2 | 4/3 | 4/4 | 4/5 | 4/6 | 4/7 | Volume Diff (6 Day) |
Client A | 8 | 10 | 10 | 9 | 10 | 12 | 15 | +7 |
Client B | 15 | 12 | 11 | 8 | 10 | 13 | 10 | -5 |
Client C | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 0 |
Client D | 20 | 15 | 13 | 2 | 15 | 30 | 40 | +20 |
<tbody>
</tbody>
Here's what I"m getting (example)
Date | 4/1 | 4/1 | 4/2 | 4/2 | 4/3 | 4/3 | 4/4 | 4/4 | 4/5 | 4/5 | 4/6 | 4/6 | 4/7 | Volume Diff (6 Day) |
Client A | 8 | Volume Diff (6 Day) | 10 | Volume Diff (6 Day) | 10 | Volume Diff (6 Day) | 9 | Volume Diff (6 Day) | 10 | Volume Diff (6 Day) | 12 | Volume Diff (6 Day) | 15 | +7 |
Client B | 15 | Volume Diff (6 Day) | 12 | Volume Diff (6 Day) | 11 | Volume Diff (6 Day) | 8 | Volume Diff (6 Day) | 10 | Volume Diff (6 Day) | 13 | Volume Diff (6 Day) | 10 | -5 |
Client C | 10 | Volume Diff (6 Day) | 10 | Volume Diff (6 Day) | 10 | Volume Diff (6 Day) | 10 | Volume Diff (6 Day) | 10 | Volume Diff (6 Day) | 10 | Volume Diff (6 Day) | 10 | 0 |
Client D | 20 | Volume Diff (6 Day) | 15 | Volume Diff (6 Day) | 13 | Volume Diff (6 Day) | 2 | Volume Diff (6 Day) | 15 | Volume Diff (6 Day) | 30 | Volume Diff (6 Day) | 40 | +20 |
<tbody>
</tbody>
* Where it says Volume Diff (6 day) my measure shows up after eachday doing the calc 6 days back ---- But I just want it on the last date..
Hope this makes sense.....Appreciate any help.
Thanks