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
⋅ 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/managing-data-presentation-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
⋅ April 16, 2019
Thanks Dmytro, we'll give this a go.
