Forum Discussion

EasyNet's avatar
EasyNet
Frequent Visitor
8 years ago
Solved

VISUAL HOUR FOR DAY

Kind Regards.

 

May be this is a simple question but is dificult for me, i need show a visual of the first and last hour of visit for a saleforce in a company, i don´t have any visual for show the hour like a value, example: in the y axis must be the hour range and the x axis must be the day and each bar correspond to the hour for these day.   In the picture is the table.

 

Thanks for your help.

 

  • Hi EasyNet,

     

    As Y-axis only supports numeric fields, it is not available to show hour values formatted as "HH:MM:SS" on Y-axis. As a workaround, you could first create two calculated columns which extratc "start hour" and "end hour" from [MIN_HORA_INICIO] and [MAX_HORA_INICIO], both are numeric values. Then, import custom visual Gantt Chart by MAQ Software.

     

    Best regards,

    Yuliana Gu

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi EasyNet,

     

    As Y-axis only supports numeric fields, it is not available to show hour values formatted as "HH:MM:SS" on Y-axis. As a workaround, you could first create two calculated columns which extratc "start hour" and "end hour" from [MIN_HORA_INICIO] and [MAX_HORA_INICIO], both are numeric values. Then, import custom visual Gantt Chart by MAQ Software.

     

    Best regards,

    Yuliana Gu

    • EasyNet's avatar
      EasyNet
      Frequent Visitor

      thank you very much ! That was what I needed, best regards!

  • MAQSupport's avatar
    MAQSupport
    Solution Supplier

    Hello EasyNet,

     

    We are glad to here to hear that you are using 'Gantt Chart by MAQ Software'.

    If you are facing any issues with the visual, we can be reached at [email protected]

     

    Thanks!!