nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I filter out Tempo Accounts by Account Status in EazyBI reports?

Daniel Woolfson_cwlijq

Hello,

I have JIRA Software Cloud and I use Tempo Timesheets and Tempo Planner. I wish to make an EazyBI report to show all billed hours for each JIRA issues by Account. But I am unsure how to exclude Accounts of status "Closed" and "Archived". I have a dimension for "Account", but I do not have a property for Account Status.

What MDX would I need to write to filter out Tempo Accounts using the existing Account Dimension in EazyBI? Or would I need to import "Account Status" as a dimension - if so how do I do this?

Daniel.

Accepted answers

All comments

Martins Vanags_eazyBI

Hi Daniel,

In our current eazyBI version, it would not be possible to import Account Status as a dimension neither as a property. We will add this in one of the upcoming eazyBI versions and then will let you know.

Please contact support@eazybi.com if you have further questions regarding this!

Kind regards,

Martins Vanags / support@eazybi.com

Daniel Woolfson

Hi Martins,

Do you have an update on this request to be able to import Account Status as a dimension? Alternatively - how can I filter out in an EazyBI report, ccounts based on the Account Name e.g. If I was to put the word "Closed" in the name and filter these out?

Daniel.

Daniel Woolfson_cwlijq

Hi Martins,

Do you have an update on if it is now possible to import Account Status as a dimension or a property?

I need to be able to filter out Tempo Accounts which are closed since the list is starting to get long and also the reports I have produced are timing out.

Daniel.

Daniel Woolfson_cwlijq

@martins vanags

Rodolfo

Hi @[deleted]any update on this feature?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

eazybi

addon-com.eazybi.jira.plugins.eazybi-jira