November 6, 2014 at 8:47 am
Hi guys,
Just getting back into SSRS after a few years out doing SSIS (I'm starting to remember why I hated it so much 🙂 )
I have a dataset related to rental debts and one of the values is net movement in debt. The rent is billed weekly, but the client pays monthly so I see the following data pattern#
Week____Movement
1_______+100
2_______+100
3_______+100
4_______-300 (being +100 rent billed and -400 rent paid)
I am not particularly worried about the increase in debt over the previous three weeks because it is 'normal' debt
What I want to do is trend the debt by taking a rolling 13 week average (to capture the 4/4/5 nature of the weekly/monthly cycles). This trend line should then show me the 'average' normal debt plus any 'problem' debt that has not been settled.
Ideally I would like to do this in the report rather than as a calculated field in the database results
I am going to display this in a sparkline but I expect the logic and technique will apply to any chart type.
TIA
Obiron
November 12, 2014 at 4:31 am
the short answer is you can't , you havre to convert it to a full chart and turn off all the axis, chart title and legend
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply