1 2 Previous Next 25 Replies Latest reply on Jul 1, 2020 9:18 PM by fac586

    Group displayed instead of Title in a bar chart

    Christian Pitet

      Hi

       

      I have a bar type chart. When you scroll down you can see "Groupe" instead of the title.

      Snap 2020-06-26 at 14.32.20.png

      I am running APEX 20.1.

       

      There are two chart series and Titre (Title) is being displayed at the upper of the chart but when you scroll down the chart it is "Groupe" which is displayed.

       

      select pk, substr(titre, 1, 45) || '...' as Titre,
      date_prise_en_charge - cree_le "Délai de prise en charge" 
      from dt_informatique 
      where date_prise_en_charge is not null
      and date_fin_travail is not null
      and cree_le between TO_DATE ('01/01/'||:P31_ANNEE4, 'DD/MM/YYYY') AND TO_DATE ('31/12/'||:P31_ANNEE4, 'DD/MM/YYYY')
      order by cree_le;
      

       

      select pk, substr(titre, 1, 45) || '...' as Titre,
      round(date_fin_travail - date_prise_en_charge, 1) "Délai de réalisation"
      from dt_informatique 
      where date_prise_en_charge is not null
      and date_fin_travail is not null
      and cree_le between TO_DATE ('01/01/'||:P31_ANNEE4, 'DD/MM/YYYY') AND TO_DATE ('31/12/'||:P31_ANNEE4, 'DD/MM/YYYY')
      order by cree_le;
      

       

      How to display Titre on the whole chart ?

       

      Best regards.

        1 2 Previous Next