8 Replies Latest reply on Jun 27, 2013 9:04 AM by side

    Result not displaying in charts if non integer values

    side

      I am trying to display values in a Chart and as soon as I put a non integer value in the table, the column disapears from the graph. I can't explain this one though there has to be a simple explanation. I started from the example Tetragrammaton Dashboard from Anvil dataworks in which they use the same technique with delemited data.

       

      Scenario 1

       

      Values;

      Values 1.png

      Result

      Chart1.jpg

       

      Scenario 2

       

      Values

       

      Values 2.png

       

      Result

      Chart 2.jpg

       

      Definition from the Chart setup;

       

      Chart Data is set to ; Current record (delimited data)

      Y-Axis is set to ; Sum(DB BP Lignes::MO Design) & ¶ & Sum(DB BP Lignes::MO CNC) & ¶ & Sum(DB BP Lignes::MO Contrôle Qualité)

      MO Design, MO CNC, MO Contrôle Qualité are defined as Numeric values in the database.

      Definition.png

       

      Also notice the data in the X-Axis don't show in the graph.

       

      I've been working on this one for hours and I have to admit I can't overcome this one.

       

      Thank you for your help