Skip to Content
author's profile photo Former Member
Former Member

Refreshing list view upon selecting piece of pie

Hi All,

We developed a functionality where a pie chart is drilling down to a list view. In the list view's connection we put it as Refresh trigger "when value changes" where value is the destination of pie chart. B2(as below)

For Ex: Pie chart shows 3 status: Status1, Status2, Status3

Combo box with 2 values, combo box1, combo box2

List view will populate dynamically upon clicking on each of the piece of pie.

1)For combo box1 selection, in the pie chart status1 has 4 records, status2 has 5 records, status3 has 6 records

When I click on status1, 4 records are getting populated in list view correctly.

2)For combo box2 selection, in the pie chart status1 has 7 records, status2 has 8 records, status3 has 9 records

When i click on status1, list view is not getting refreshed still it shows the above 4 records i.e. for the previous selection.

I could understand that it is due to the refresh trigger " when value changes" in the connection of list view.

But can anyone please guide me in refreshing the list view upon selection of same piece of pie with combo box selections.

pie.jpg (6.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on May 20, 2015 at 10:17 AM

    As you said it could be the issue of trigger cell, take a snap of the data for a particular selection and see what happens in the background. Also i would suggest you to keep a push button as submit button finally to trigger the selection otherwise for every selection the query gets refresh.

    Difference between "When value Becomes & When value Changes"

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.