Database View Right Join

[Scott Parrish]

I need to join Incidents with the Metric Instances to get the on hold times of resolved tickets, but also need to get all other incidents that are resolved or closed that did not have an on hold time. I was hoping there was a way to create a database view right join where I joined the On Hold instances that matched Incidents and returned all other Incidents. Any ideas on how I can accomplish this?

[-O-]

That is a custom Metric, basically a copy of the Incident State Duration one - just that it is for field Sate vs. Incident state.

As for OOB metrics not being OK, cause they create multiple metric instance entries, there are two points to highlight:

- that is a "problem" no matter what kind of join one uses - don't confuse joins with groupings and aggregations

- that can be solved if the view is consumed by a report that does the proper groupings and aggregations.

One could also come up with an "advanced" metric that aggregates metric instances, so one has one metric instance record per incident per definition per field value - but this will not be retroactive, so that might be an issue. But even that could be fixed with a Fix script that aggregates existing duration.

As for the SN version, it is totally irrelevant to the situation.

[Scott Parrish]

This is why I asked if there was a way to create a right join. The only confusion on my part was that you used a custom metric to demonstrate something as "working" when indeed it does not. Next time if you want to t be helpful then I would suggest posting a screenshot that matches what the person is trying to do. Thank you for the effort.

[-O-]

I'm not trying to pick on you, but:

This is why I asked if there was a way to create a right join.

Actually what you asked was:

Any ideas on how I can accomplish this?

And I have described to you how to do it.

Second:

The only confusion on my part was that you used a custom metric to demonstrate something as "working" when indeed it does not.

How did you come to that conclusion? Did you implement what I described? I did - results after the replies*.

Next time if you want to t be helpful then I would suggest posting a screenshot that matches what the person is trying to do.

Next time

- state all your requirement upfront, that it must be based on an OOB metrics - Nostradamus does not post here

- when someone describes you a solution, first try to implement it than judge

- also try not to bite the hand that tries to feed you - others might be turned off too when they see your attitude.

Using right join will 100% not work.

What I described 100% works.

*) Why bother?

[Scott Parrish]

What is described in no way works. 

[-O-]