I am actually more interested in the built-in charts, for example the Memory/Page Life Expectancy chart in DPA - The 'Day' option just shows me today and the week option just shows me the current week but in neither case can I compare it with the previous period. I was initially thinking of requesting that it show 8 days instead of a week, but reading ianrivers comment, I realized that the best option would simply show this week and the previous week on the same chart but in different colors.
I came across with the same question and I haven't found any information about it.
For me it would act as a baseline (which as far as I understood NPM has it, but it just calculates new thresholds to configure alerts). I needed a graph showing the real information (e.g: Today) and another line (As a trend line) showing up the collected data based on yesterday's data and so on (Sunday with last sunday's, etc).
I intend to do that to analyse if my current chart is doing good according to daily traffic.
1 of 1 people found this helpful
No display of this type currently exists in the normal UI. This is definitely doable with custom sql/swql as the datasource of a custom chart, but it would take some manipulating of the data. Build the query how you want it for this week, join the same type of query with the time range showing to the previous week's data, modify the timestamps on these old values forward a week, indicate on the labels which line is current data and which is "old"
You would also have to make sure your retention settings are set up to accommodate this, since the default behavior for most metrics is to summarize stats to hourly averages after a week.
Thank you very much for the tip.
Basically we created two custom queries with different timestamps and joined them together in order to create the baseline column as you said. It did needed some data manipulation (It took us some time), but it worked.
We will run some tests now.
By the way it would be awesome to have such feature in the next releases. I will open a feature request in the support center.
Thanks again.. =)