I would like to know if there is any way to represent the week in the date natively when using JSON data as row or column?
Thank you very much
Thank you for contacting us.
We would like to kindly inform you that such an aggregation is not included is the list of data types supported by Flexmonster by default. We recommend preprocessing the data set so it contains all required fields including the week number and present it as multilevel hierarchy.
You are welcome to check out an example we have prepared in order to demonstrate the mentioned approach.
We hope it works for you.
Thank you very much for your answer, we will be using your proposed approach.