How to Input a Constant Value in Report for each Month

Questions & Answers
1

Hi guys,

I have a report that already has my JIRA data; however, I want to manually add some values for each month.

For example, I would like to add one more column with specific manually-inserted values for each month as shown below:

1
1503×955 10.8 KB

is there a way to manipulate a custom formula to add those manual values?

Thank you!

2

Hi @Kyung_Park

There are a couple of ways how to do this, the simplest one would be to create a new measure in the Measures dimension and use a formula like this:

CASE [Time].CurrentHierarchyMember.Name
  WHEN "Jan 2024" THEN 100
  WHEN "Feb 2024" THEN 150
  WHEN "Mar 2024" THEN 130
  WHEN "Apr 2024" THEN 200
  WHEN "May 2024" THEN 140
  WHEN "Jun 2024" THEN 170
  WHEN "Jul 2024" THEN 110
  WHEN "Aug 2024" THEN 100
  WHEN "Sep 2024" THEN 150
  WHEN "Oct 2024" THEN 200
  WHEN "Nov 2024" THEN 130
  WHEN "Dec 2024" THEN 130
  WHEN "Jan 2025" THEN 120
  WHEN "Feb 2025" THEN 110
END

​Let me know if this fits your use case or if you have any additional questions on this!
​Best regards,
​Nauris

3

Thank you so much, this is what I was looking for.

4

I have a very similar use case but with a lot more data and would like to know if there is a more efficient way to update/import this data.

We have 4-month planning periods and have a Jira custom field for identifying the period the story is completed in. We also have about 10 teams/Jira spaces. For each planning period and team intersection, there is a fixed value of estimated total story points I would like to add to reports.

Is the answer to this original post still the best way to define the values in eazyBI?

Thanks, Tim

5

Hello @timz ,

The above method works fine if a set of data has to be added.

If you need to enter a high amount of static data values and the fields are single-select, separate table dimensions, then you might use external data import to populate the data.
Please read more about that here - https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube.

First, the Team field should be imported as a single-select separate table dimension to enable data mapping against it (https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube#AdditionaldataimportintoJiraIssuescube-Mappingtosinglevaluecustomfielddimensions).

Then, you can set up the external data source and perform data mapping. Please ensure to have explicit date for value reference.

Since the imported values will only be mapped to a few dimensions, you need to reset the rest of the report context when retrieving values.
The best way might be as follows.

-- only retain the context of explicitly stated dimensions
DefaultContext(
([Measures].[<imported measure>],
 [Team].CurrentHierarchyMember,
 [Time].CurrentHierarchyMember))

This should allow you to get the saved values in reports based on Jira data.

Regards,

Oskars / support@eazyBI.com