Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Is there support for "week" on dates in JSON?

Resolved
Projet TCD asked on February 24, 2020

Hello,
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?
Either as:

  • New types like “weekOfYear” (equivalent to Excel WEEKNUM for week starting on Sunday or ISOWEEKNUM for week starting on monday) and “weekOfMonth” (based on one or the other value)
  • Hierarchy year/quarter/month/week/day

Thank you very much
Best regards,

2 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster February 24, 2020

Hello,
 
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.
 
Best regards,
Illia

Public
Projet TCD February 28, 2020

Hello Illia,
 
Thank you very much for your answer, we will be using your proposed approach.

Please login or Register to Submit Answer