How to group time dimension in two part i.e. first 15 days and next 15 days

Questions & Answers
1

Hi Team ,

Need help , i am creating a report which should give me number of stories created in first 15 days and next 15 days for the given month.
Something like the below
Aug ------- # issues created
1-15 – 10
16-30 —5
Sept
1-15 ----1
16-30-- 3
Any idea how to achieve this

2

Hey, @Uttam,

Welcome to the eazyBI communtiy!

If you’re into tracking Stories by time intervals, please consider creating a new custom time hierarchy in the Time dimension. Learn more about: Custom time hierarchies

Please consider splitting the month into two parts, like 1-15 and 16 onwards, using JavaScript code. Please check out examples and details of Calculated time hierarchies: Custom time hierarchies

In the Time dimension, please choose “Add custom hierarchy”, this option is available for users with account Owner, User Admin, or Data Admin user roles.

Add custom hierarchy
Add custom hierarchy438×700 34.3 KB

Choose the type (calculated), define the name, and select the levels (year, quarter, month, and day).
The JavaScript code that divides the month into two parts (1-15, 16-…) should look something like this:

const monthName = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"];


var month = timeValue.getMonth();
var year = timeValue.getFullYear();
const quarter = Math.ceil((month+1)/3);

var monthStartDate = new Date(year, month, 1)
const dayInMonth = Math.ceil((timeValue.getTime() - monthStartDate.getTime()) / 86400000.0);

monthPart = dayInMonth > 15 ? 2 : 1

return {
  year: year,
  year_name: year,
  quarter: quarter,
  quarter_name: "Q" + quarter + " " + year,
  month: month*2 + monthPart,
  month_name: monthName[month] + "-" + monthPart + " " + year,
  day: timeValue.getDate(),
  day_name: strftime("%B %d %Y", timeValue)
}

If selecting this new hierarchy in the Time dimension, the report should look something like this:

custom Time hierarchy
custom Time hierarchy1226×974 99.2 KB

Kindly,
Ilze suppot@eazybi.com