recognice in Insight that a user has already replaced 4 devices in 2 year for example

[Marco Brundel]

In CDMB Insight our customer, Vitens, register smartphones.

Their question is whether it can be recognized that a user has already replaced 4 smartphones in 2 years. Do you have a tip, idea how this can quickly be recognized?

[PJ Wysota · Accepted solution]

Hi,

Nice case, although difficult.

The problem is that IQL is limited query language and integration of Insight objects with JIRA ticket is kind of abstract one. But few hints, starting from simplest one (and not knowing structures of your JIRA and Insight structures):

1. Using specific Category for such issues - then running a query in JIRA (JQL) directly - for all positively closed (approved and resolved) against specific customer. Then You are disregarding Insight data.
a) Categories might be also managed within Inisght (as metadata) - but it is a side note - then you could limit filters based on other field values - other way than with JIRA select fields.

2. Having Insight User Objects connected with JIRA users to match reporters to Insight data, and adding Number/Integer attributes for counts of specific operations, then developing Insight Postfunctions for workflows increasing/decreasing these values based on some defined cryteria. It would require a bit of setups and testing plus of course - the more specific cases  - the more attributes, and you need to keep some common sense here.

3. It might be (might) that something like this report You could run using eazyBI with import of JIRA and Insight data, but...
1) Insight and JIRA data are imported into separate cubes - they have some references across one another, but I am not sure without designing specifc case if these would be enough.

2) I would go into something like: JIRA issues with reference to (specific user AND specific object types (phones) AND specific Insight object status change )