1

No plot null values

I need the chart to NOT plot the null values in % Acumulada Real. One year waiting fix this problem.

12 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view

    https://forum.ninox.com/t/q6hbwyp
     

    Wasn't the problem solved? 
     

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      RoSoft_Steven Hi Steven, Yes the problem has not been solved. The image above is misrepresented and the below as misrepresented too.

      • Ninox partner
      • RoSoft_Steven.1
      • 1 yr ago
      • Reported - view

      Rafael I made it work with Google Charts:

      Code in the GoogleChart formula field:

      let ti := "['Date','Accumulado Plan','Accumulado Real'],
";
let chartdata := join(for i in select Avances do
        "['" + text(i.'FechacCorre de la Semana') + "'," +
        replace(text(number(i.'% Acumulado Plan')), ",", ".") +
        "," +
        if i.'% Acumulado Real' > 0 then
            replace(text(number(i.'% Acumulado Real')), ",", ".")
        else
            "null"
        end +
        "]"
    end, ",
");
chartdata := ti + chartdata;
let gscode := "<html>
  <head>
    <script type='text/javascript' src='https://www.gstatic.com/charts/loader.js'></script>
    <script type='text/javascript'>
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);
      function drawChart() {
        var data = google.visualization.arrayToDataTable([" +
    "
" +
    chartdata +
    "
" +
    "        ]);
        var options = {
          title: 'Curva Consolidada Planificado vs Real',
          legend: { position: 'bottom' },
          interpolateNulls: true
        };
        var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));
        chart.draw(data, options);
      }
    </script>
  </head>
  <body>
    <div id='curve_chart' style='width: 1000px; height: 500px'></div>
  </body>
</html>";
html(gscode)
      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      RoSoft_Steven Hi Steven, you have the DB where you Created the Graph ? If Yes can you send me it ? I need something else to create the Graph ?

      Appreciate. Great work. 👍

      • Ninox partner
      • RoSoft_Steven.1
      • 1 yr ago
      • Reported - view

      Rafael yes, I'll post it here tomorrow... with a second type of graph.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      RoSoft_Steven Thanks Steve 👍

      • Ninox partner
      • RoSoft_Steven.1
      • 1 yr ago
      • Reported - view

      Here's the database with 3 different types of google charts, selectable with a choice field.

      More about google chart types here.

      The chart is in the table 'Avances' in the record-tab 'Chart'.

      Alivio y Venteo With Google Charts.ninox
      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      RoSoft_Steven Thanks for your help Steven works excelent, Display as it should be.

      I don't know what Ninox expects to solve this problems in its graphics

      Again appreciate your time.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      RoSoft_Steven Hi Steven.

      Where can change from line graph to Bar Graph, I need other graphics with Bar Chart.

      thanks

    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view

    You can use the choicefield Charttype and choose Steppenareachart for a Bar Chart.

    Not sure if you can use more types of chart than these three with zero values, but more about google chart types here.

    Hope this helps....

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      RoSoft_Steven Another Curve with 0 Value on Google Chart (Burndown Chart) 👍 Thanks you very much for your contribution.

      • Ninox partner
      • RoSoft_Steven.1
      • 1 yr ago
      • Reported - view

      👍

Login to reply

Content aside

  • Status Answered
  • 1 Likes
  • 1 yr agoLast active
  • 12Replies
  • 304Views
  • 2 Following