How to group by date

Chris Anderson asked on April 15, 2019

Hi there,
Is there any way to group dates by month / year within the GUI itself if the raw data is provided in a flat structure with a specific date per row?
E.g. Data looks like this:

Date
Value

02/02/2019
4

03/02/2019
5

04/03/2019
2

05/03/2019
4

Using your online demo and a local csv file I can upload the data but cannot find a way to group and chart the data by month (as an example).
I found the link below but I wasn’t 100% sure I understood the answer.
https://www.flexmonster.com/question/grouping-field-or-hierarchy-dimension-field/
Our use case will provide user defined lists of data to FlexMonster in either JSON or CSV format. It will be for the user to determine whether they would like to group on date, based on their requirements.
Thanks in advance,
Chris
 

2 answers

Public
Dmytro Zvazhii Flexmonster April 16, 2019

Hello Chris,
Thank you for posting your question here.
You need to add some changes to your sample data.
Please refer to the following article: https://www.flexmonster.com/doc/data-types-in-csv/.
It describes how to define the data types explicitly.
Also, please note that Flexmonster supports only ISO 8601 date format for input. 
It means that you need to change the date format from “02/02/2019” -> “2019-02-02”.
Please let us know if everything works fine for you.
Regards,
Dmytro

Public
Chris Anderson April 16, 2019

Thanks Dmytro, we’ll give this a go. 

Please login or Register to Submit Answer