Forum Discussion

XavierSob's avatar
XavierSob
New Member
8 years ago
Solved

Histogram with date

Dear All,

First message here, thank you for the support and the space.

 

I have a list of delivered units, with for each delivery the date, which is month-year (eg. 01-2016; 07-2017; ...) I would like to have an histogram with for each month (if possible from jan to december) the cumulated number of delivery.

I can change my inputs as needed, but so far cannot find the solution.

 

I need to identify on the x-axis what is the month+year. Doing it by changing the date into a number works but is not usufull as I lost the time information.

 

Thanks in advance for your help.

eg. of data

Delivery ref. / Date

#1 / 01-2016

#2 / 01-2016

#3 / 03-2016

#4 / 03-2016

#5 / 12-2016

#6 / 12-2016

#7 / 01-2017

#8 / 02-2017

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi XavierSob,

     

    You can refer to below steps if it suitable for your requirement:

     

    Steps:

    1. Add calculated column to convert month-year to date value.

    DateValue = DATEVALUE([Date])

    2. Use above column and 'Delivery' column to create visual.(drag month part of DateValue to axis, year part to legend, Delivery to value field.)

     

    Regards,

    Xiaoxin Sheng

3 Replies

  • Dear All,

     

    First message here, thank you for the support and the space.

     

    I have a list of delivered units, with for each delivery the date, which is month-year (eg. 01-2016; 07-2017; ...)

     

    I would like to have an histogram with for each month (if possible from jan to december) the cumulated number of delivery.

     

    I can change my inputs as needed, but so far cannot find the solution.

    I need to identify on the x-axis what is the month+year. Doing it by changing the date into a number works but is not usufull as I lost the time information.

     

    Thanks in advance for your help.

     

     

    eg. of data

     

    Delivery ref. / Date

    #1 / 01-2016

    #2 / 01-2016

    #3 / 03-2016

    #4 / 03-2016

    #5 / 12-2016

    #6 / 12-2016

    #7 / 01-2017

    #8 / 02-2017

     

  • Hi,

     

    I cannot visualise your result.  Plase show how you'd like the result to look like.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi XavierSob,

     

    You can refer to below steps if it suitable for your requirement:

     

    Steps:

    1. Add calculated column to convert month-year to date value.

    DateValue = DATEVALUE([Date])

    2. Use above column and 'Delivery' column to create visual.(drag month part of DateValue to axis, year part to legend, Delivery to value field.)

     

    Regards,

    Xiaoxin Sheng