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
    • 11 mths ago
    • Reported - view

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

    Wasn't the problem solved? 
     

      • Rafael Sanchis
      • Rafael_Sanchis
      • 11 mths 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
      • 11 mths 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
      • 11 mths 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
      • 11 mths ago
      • Reported - view

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

      • Rafael Sanchis
      • Rafael_Sanchis
      • 11 mths ago
      • Reported - view

      RoSoft_Steven Thanks Steve 👍

      • Ninox partner
      • RoSoft_Steven.1
      • 11 mths 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'.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 11 mths 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
      • 11 mths 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
    • 11 mths 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
      • 10 mths 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
      • 10 mths ago
      • Reported - view

      👍

Content aside

  • Status Answered
  • 1 Likes
  • 10 mths agoLast active
  • 12Replies
  • 261Views
  • 2 Following