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 ...
  • 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

XavierSob's avatar
XavierSob
New Member
8 years ago

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