Sniklfritz
New Member
- Joined
- Apr 3, 2017
- Messages
- 17
Hey all,
I have run into a snag.
I have a query that has transactional flight bookings and one of the columns is KMs.
What I am trying to do is create a line graph that shows a cumulative line, but anytime i try it "sums" just for the period along the X axis...
I do have a dimension table for date that i thought i could add a custom column to maybe have a running total against each day but i wasnt sure if that would fix the problem...
Ideally i would like the line chart to also handle changing from daily>monthly>yearly.
Any ideas?
I have run into a snag.
I have a query that has transactional flight bookings and one of the columns is KMs.
What I am trying to do is create a line graph that shows a cumulative line, but anytime i try it "sums" just for the period along the X axis...
I do have a dimension table for date that i thought i could add a custom column to maybe have a running total against each day but i wasnt sure if that would fix the problem...
Ideally i would like the line chart to also handle changing from daily>monthly>yearly.
Any ideas?