Title: Problem in chart
Last modified: August 21, 2016

---

# Problem in chart

 *  [anespa](https://wordpress.org/support/users/anespa/)
 * (@anespa)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/problem-in-chart/)
 * Dear Claudio,
 * I checked your solution , it’s work fine , thanks alot .
    But there is one issue
   in showing the data tooltip when the goal standard line is present in the graph
   as shown in fig : Problem view – Click on another place.png
 * [http://postimg.org/image/3wp59k5zr/](http://postimg.org/image/3wp59k5zr/)
    But
   it work fine ,if Goal line is avoided as shown in fig: proper pointing.png [http://postimg.org/image/859xq8wc3/](http://postimg.org/image/859xq8wc3/)
 * My setting is like in fig : setting.png
 * [http://postimg.org/image/fkhi2xs7v/](http://postimg.org/image/fkhi2xs7v/)
 * Please check it and advise .
 * Thanks,
    Anes
 * [http://wordpress.org/plugins/wp-business-intelligence-lite/](http://wordpress.org/plugins/wp-business-intelligence-lite/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [claudio](https://wordpress.org/support/users/calberti/)
 * (@calberti)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/problem-in-chart/#post-4165726)
 * Hi Anes,
    can you please post also the tabular data that you obtain when testing
   the query? I need to understand what’s the expected behaviour. I mean, are there
   values in the “goal” column of the result? thanks Claudio
 *  Thread Starter [anespa](https://wordpress.org/support/users/anespa/)
 * (@anespa)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/problem-in-chart/#post-4165736)
 * Dear Claudio,
    There is value in the goal column and it’s value is fixed (89).
   My expected behaviour is when click on the points the value in tooltip must display
   properly , all others are working well now. I attach the tabular data when query
   execute below:
 * [http://postimg.org/image/ejypnw7r5/](http://postimg.org/image/ejypnw7r5/)
 * Please advise me
    Thanks, Anes
 *  [claudio](https://wordpress.org/support/users/calberti/)
 * (@calberti)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/problem-in-chart/#post-4165755)
 * Hi Anes,
    The behaviour is weird, I cannot reproduce it. Can you maybe try to
   set the dates in ascending order? I think that maybe having shuffled dates can
   have an impact on rendering. claudio
 *  Thread Starter [anespa](https://wordpress.org/support/users/anespa/)
 * (@anespa)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/problem-in-chart/#post-4165758)
 * Dear Claudio,
    I checked the query with ORDER BY add_date DESC but still the 
   same problem occurs . I attach the settings and my db table sql files regarding
   this issue . [http://www.mediafire.com/view/1qbqvjfv31whlam/wp_weight.sql](http://www.mediafire.com/view/1qbqvjfv31whlam/wp_weight.sql)
   [http://www.mediafire.com/view/10gwvq05c7ag3qj/wp_users_test.sql](http://www.mediafire.com/view/10gwvq05c7ag3qj/wp_users_test.sql)
 * Settings preview
    [http://postimg.org/image/wytn2hnb5/](http://postimg.org/image/wytn2hnb5/)
   You can find my working query in preview itself .
 * Please advise a solution for this.
 * Thanks,
    Anes
 *  [claudio](https://wordpress.org/support/users/calberti/)
 * (@calberti)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/problem-in-chart/#post-4165792)
 * Hello Anes,
    actually I found out that this happens because one serie has the
   same value as the other. It must be a bug with nvd3.js the chart library we use
   in the plugin. We’re currently looking into it. Anyway with other configurations
   of point the issue seems to be not present. I’ll let you know as soon as I find
   a solution. regards Claudio

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Problem in chart’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-business-intelligence-lite_eae8f9.
   svg)
 * [WP Business Intelligence Lite](https://wordpress.org/plugins/wp-business-intelligence-lite/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-business-intelligence-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-business-intelligence-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-business-intelligence-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [claudio](https://wordpress.org/support/users/calberti/)
 * Last activity: [12 years, 7 months ago](https://wordpress.org/support/topic/problem-in-chart/#post-4165792)
 * Status: not resolved