# Tracking Sold vs Logged Hours per Organization in Jira Service Management with EazyBI **URL:** \ **Category:** Questions & Answers\ **Created:** [February 10, 2026, 7:30am UTC](https://community.eazybi.com/t/tracking-sold-vs-logged-hours-per-organization-in-jira-service-management-with-eazybi/20642 "2026-02-10T07:30:18Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![pablo\_bagliere](https://community.eazybi.com/letter_avatar_proxy/v4/letter/p/ed655f/32.png) [@pablo\_bagliere](https://community.eazybi.com/u/pablo_bagliere)\ **Post date:** [February 10, 2026, 7:30am UTC](https://community.eazybi.com/t/tracking-sold-vs-logged-hours-per-organization-in-jira-service-management-with-eazybi/20642/1 "2026-02-10T07:30:18Z")
Hello, We are starting to use EazyBI in our company, and I would like to know if the following scenario is possible to implement. We use Jira Service Management (JSM) and work with Organizations on tickets. We log work hours normally, but our clients purchase either hour packages or fixed monthly hour contracts. What we would like to achieve is a report that shows, per organization: - The total hours logged - The total hours sold according to the contract - The remaining available hours for each client per month An example report would look like this: | Organization | Logged Hours | Sold Hours | Available Hours | | --- | --- | --- | --- | | Org1 | 10 | 20 | 10 | | Org2 | 5 | 15 | 10 | | Org3 | 8 | 10 | 2 | Is this possible to build using EazyBI? If so, could you please indicate how this could be done or point me to any documentation or tutorial to implement it in the simplest possible way? Thank you very much in advance for your help. ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [February 10, 2026, 9:51am UTC](https://community.eazybi.com/t/tracking-sold-vs-logged-hours-per-organization-in-jira-service-management-with-eazybi/20642/2 "2026-02-10T09:51:16Z")
Hi @pablo_bagliere Could you please share more details about the use-case. I’m wondering where do you enter “sold tickets” for an organization in Jira? Is that some custom field you have somewhere you you maintain a seprate file with organization hour packages? Logged hours is easy to calculate, using “Hours spent” measure and “Organization” dimension, but i’m not sure how to get “Sold hours” in your case See some dashboard here: > **[Time Tracking - Jira Demo - eazyBI](https://eazybi.com/accounts/1000/dashboards/27385-time-tracking)** And check this page on how to import “Organizations” as dimension. > **[Jira Service Management custom field import - Jira Service Management custom...](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-service-management-custom-fields#JiraServiceManagementcustomfields-JiraServiceManagementcustomfieldimport)** > > On this page: Martins / eazyBI support ---
**Author:** ![pablo\_bagliere](https://community.eazybi.com/letter_avatar_proxy/v4/letter/p/ed655f/32.png) [@pablo\_bagliere](https://community.eazybi.com/u/pablo_bagliere)\ **Post date:** [February 10, 2026, 12:45pm UTC](https://community.eazybi.com/t/tracking-sold-vs-logged-hours-per-organization-in-jira-service-management-with-eazybi/20642/3 "2026-02-10T12:45:27Z")
Hello, We save the hours sold in the organization information, but we are not sure how to display them in the report. We tried importing them from a Google spreadsheet to the Issues cube, but it is not possible to create new dimensions. Nor is it possible to modify the Organization dimension to be able to use that data. That is why we wanted to ask if there is any way to achieve this. Example photos ![image](https://community.eazybi.com/uploads/default/original/2X/d/d598e44013515f8edd98afabafb54620ab9dbfbc.png) ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [February 10, 2026, 3:15pm UTC](https://community.eazybi.com/t/tracking-sold-vs-logged-hours-per-organization-in-jira-service-management-with-eazybi/20642/4 "2026-02-10T15:15:30Z")
@pablo_bagliere **Organizations** is a multi-value field in Jira and such fields when imported as dimensions in eazyBI, do not support additional data import from additional data sources (files or applications). The only workaround I can imagine for eazyBI reports is if you use just **one** organization per ticket (at all times). In that case, you create a new [account-specific calculated custom](https://docs.eazybi.com/eazybi/data-import/data-from-jira/javascript-calculated-custom-fields/account-specific-calculated-fields) field with “separate\_table = true” settings by using JavaScript, and then you could import the additional data to this new dimension. The script should return just one organization per ticket, so you can import single-value behavior in the dimension. Later in reports, you could still use the **original** “organizations” dimension in report and, with the help of MDX formulas, return values imported to the " **new** ” organization dimension by matching dimension member names. But this concept would return **unexpected** results in reports for tickets with multiple organizations added in Jira Let me know if that sounds interesting to you. Martins / eazyBI