Forum Discussion
XavierSob
8 years agoNew Member
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 ...
- Anonymous8 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
Anonymous
8 years agoNot 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