| savedsearch "searchduration" | join TaskBP [ | savedsearch "searchavgduration" ]|eval Diff=duration-Avgduration|table TaskBP Diff|
after running this query ,i got the output as
TaskNmae Diff
A -345
B -122
C 867
D 111
What i need is i want to plot the chart so that the negative charts sholud be upside down and the positive values should be upside Top
If the fields are clearly defined and the fields have the appropriate data, then you can use the following to complement your search:
| chart list(Diff) AS Diff by TaskName
That should do it. Let us know if this works.
hi Glib,
i tried it shows the TaskName and the List od Diff values ..but it shows some error as "chart has limited size due to that some values got ignored and truncated"