title: How to set fixed y-axis values in SAPUI5 VizFrame Column Chart using XMLView?
body: <p>I have created a VizFrame Column Chart in SAPUI5 using oData. Now I need to put fixed values in y-axis (Dimension axis) since I want to show the days of the week on the y-axis, and how many hours worked in which day using the x-axis. Since I use oData date values I got from SAP, I can only show those values, but I want to show all the days in that week.</p>
  <ol>
  <li>How can I set fixed scale for y-axis, and then fill those values with oData?</li>
  <li>I want to show the time of work in the same days to be added, but I get only one value for a day, it does not add up with different data with the same date</li>
  <li>I also cannot format the Time value as HH:mm:ss setting, when I try to format like that, it does not show the column data. The formatting works on sap.ui.Table, but not on the VizFrame.</li>
  </ol>
  <p>My code in XMLView is as follows:</p>
  <pre><code>
  &lt;viz:VizFrame id=&quot;idVizFrame&quot; width=&quot;100%&quot; vizType='column' vizProperties=&quot;{title: {text: 'Weekly Timesheet Chart'}}&quot;&gt;
                          &lt;viz:dataset&gt;
                              &lt;viz.data:FlattenedDataset data=&quot;{/TasksSet}&quot;&gt;
                                  &lt;viz.data:dimensions&gt;
                                      &lt;viz.data:DimensionDefinition name=&quot;JobDate&quot; value=&quot;{ path: 'JobDate', type: 'sap.ui.model.type.Date', formatOptions: {source: {pattern: 'yyyy-MM-dd'}, pattern: 'dd.MM.yyyy' } }&quot; /&gt;
                                  &lt;/viz.data:dimensions&gt;
                                  &lt;viz.data:measures&gt;
                                      &lt;viz.data:MeasureDefinition  name=&quot;Duration&quot;
                                          value=&quot;{path: 'Duration', type: 'sap.ui.model.type.Time', formatOptions: {source:{pattern: 'HHmmss'},pattern: 'HH:mm:ss'}} &quot;/&gt;
                                  &lt;/viz.data:measures&gt;
                              &lt;/viz.data:FlattenedDataset&gt;
                          &lt;/viz:dataset&gt;
                          &lt;viz:feeds&gt;
                              &lt;viz.feeds:FeedItem id='valueAxisFeed' uid=&quot;valueAxis&quot; type=&quot;Measure&quot; values=&quot;Duration&quot;/&gt;
                              &lt;viz.feeds:FeedItem id='categoryAxisFeed' uid=&quot;categoryAxis&quot; type=&quot;Dimension&quot; values=&quot;JobDate&quot;/&gt;
                          &lt;/viz:feeds&gt;
  &lt;/viz:VizFrame&gt;
  
  </code></pre>