Insight - custom text

Question & Answer
,
1

Hi there,

I have a insight visual with the fields: Date: Date, Values: Non-compliance (sum), Categories: {Question Text} and {Region}.

I currently have a insight that shows the top ranked questions by amount of non-compliance. Is there a way I can also add to this insight by following each question with the top region that is contributing to the sum?

What it is currently:

Top.items

Top.items[index].categoryValue.formattedValue with Top.items[index].metricValue.formattedValue

What I am aiming for:
Top.items

Top.items[index].categoryValue.formattedValue with Top.items[index].metricValue.formattedValue from Region1

Thank you!

2

Hi @Roger123,
It looks to me like you’re trying to limit the Inisght to only show Region 1? What if you setup a filter on the Insight visual to limit your region results?

Let me know if this works for your case or if you were looking to achieve something different!

3

Hi Brett,

Thank you, that’s not quite the aim.

Let’s say question 1 has 100 answered no, 70 from region A and 30 from region B.

I’m seeking help in creating an insight that shows:
“Too questions with no are:
Question A with 100, majority from Region A
Question C with 60, majority from Region D
“

The region would be a dynamic field specific to each bullet point presented.

Thank you for your help

4

Hi @Roger123,
Sorry for the delayed response while I tried to work through this a bit further. I’ve put together an Arena view with sample data for you to explore that got a similar outcome to what you’re looking to achieve.
Insight - custom text

Essentially, you’ll have to do separate calculated fields and then use the insight to draw that information out as opposed to trying to accomplish all within the insight.
You have to start by creating a denserank for your questions (for my example, I did ‘Customer’).
Then you need to create a denserank for customer by region.
(Check any field in the field well that are calculated fields as they were utilized in this scenario).
The other thing that I will mention, depending on how many questions you’d like to include in your insight, you may run in to a field quantity limitation.

1 Like
5

Hi @Roger123,
Following up here as it’s been awhile since we last heard from you. Did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

6

Hi @Roger123,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!