0

Fix 0 Value on Line Curve Graph

How to Fix these problem with the Graph Curve ? The green curve no 0 values

12 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    Why is %Accumulado Real = 0 after 1 Apr 2022? You need to check your data to find out why?

    %Accumulad Real is a formula field. Trace the data that field uses to see where the problem is.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    Hi Fred.

    Remember my Real is not the spend hours my % Acumulado Real is the hour I win every week with the cut-off date is my progress of the project. The objective of the project is on time with the Planned Curve.

    • Fred
    • 2 yrs ago
    • Reported - view

    The troubleshooting is the same. You need to go to the source of the chart and check the raw data. If % Acumulado Real a number field then check the table that the chart is using. Do you see data in all the fields? If it is a formula field then check that the numbers are correct and if not then you have to check the numbers that are used in the formula.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    Fred I don't have data for week 14 to 17 and is a numeric% field 

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    That curve is that I need is in excel 

    • Fred
    • 2 yrs ago
    • Reported - view

    I get it now. You want the chart to NOT plot the null values in % Acumulada Real. Well that is beyond me. Hopefully someone with more chart experience can help. Sorry.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    Always appreciate your help Fred Thanks

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    We have already included this function in our list of requested improvements. We hope to be able to release them in one of our upcoming versions.

    Support Ninox 0

    As the real cumulative hours from future days will always be 0 (as it has not happened yet). In this case you would need to make a calculation it in a way that future days present the cumulative values form previous dates.

    You are welcome to join the Open Office to see if we can solve this issue there. If not, then for creating, designing and customizing your individual solution with Ninox, our partners will be happy to support you or do it for you.

      • Ninox partner
      • RoSoft_Steven.1
      • 2 yrs ago
      • Reported - view

      Rafael I'll check this tomorrow and reply to you.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

      RoSoft_Steven Rooryck Appreciate 

    • Ninox partner
    • RoSoft_Steven.1
    • 2 yrs ago
    • Reported - view

    Rafael Using following formula in a supplementary formulafield is the solution: 

    if '% Acumulado Real' then
    '% Acumulado Real'
else
    last(select Avances where '% Acumulado Real').'% Acumulado Real'
end

    See the blue line.

    PS: Don't know why, but it only worked after leaving the database and startup again.

    Steven

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    RoSoft_Steven Rooryck Hi Steven.

    It work it look better, thanks excelent support  appreciate your time.

    Work without leaving the DB.

    I hope that Ninox solves soon this bug.

Login to reply

Content aside

  • 2 yrs agoLast active
  • 12Replies
  • 126Views
  • 3 Following