How to create pie chart with average?

[Manoj]

Hi All,

I need your help to create a pie chart based on 2 conditions.

I have data from 2010 onwards to 2020 but i have to create a pie chart for the FY1920 [Apr 19 to mar-2020] showing the average of gender [male and female], Could you please suggest who to put this eazybi. 

and other one is based on hard coded Values of  by mar-2020 with gender for example, i have 300 male and 100 female in my team by 31-Mar-2020.

Thanks in advance.

Thanks, M

[Evan Golden {VisualScript} · Accepted solution]

VisualScript for Jira pie charts show percentages, and have an expanded view with number of issues with hyperlinks.  They can report off of any field.  I assume gender is a field?  You can create the pie chart to include parameters for start date and end date.

Let me know if you have any questions.

FYI I work on the VisualScript product team.

[Lauma Cīrule]

Hi!

In eazyBI you would define a fiscal hierarchy in the Time dimension. You can then take the year level and divide the measure by twelve (you do not need the Issues created measure, just the avg calculated member. I added the measure just for demonstration):

For the Issues created avg example measure, the formula would be as follows:

[Measures].[Issues created] / 12

Lauma / support@eazybi.com