AnsweredAssumed Answered

Result not displaying in charts if non integer values

Question asked by side on Jun 25, 2013
Latest reply on Jun 27, 2013 by 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

Outcomes