6 Replies Latest reply on Jun 9, 2017 5:12 PM by Zhouyi Zhang

# Calc field - plot bar chart

I have a 'Duration in hours' integer field for each store, year and month.

I want to plot 2 bars '+ve' & '-ve' yearly

+ve = SUM(Duration in hours) only for records where Duration > 0

-ve = SUM(Duration in hours) only for records where Duration < 0

How do I write this calculations and plot it?

• ###### 1. Re: Calc field - plot bar chart

Hi, Vishal

Is this something you are after?

ZZ

• ###### 2. Re: Calc field - plot bar chart

option 1 - looks good

option 2 - can I get -VE number with negative scale?

Both look good

• ###### 3. Re: Calc field - plot bar chart

Hi, Vishal

Please find my solution below as shown screen shot

Please let me know if you have quesiton

ZZ

2 of 2 people found this helpful
• ###### 4. Re: Calc field - plot bar chart

Thank Zhouyi.

I have one more need, how can I convert this into one pie chart showing both % -ve and % +ve as slice as percentage for each year?

• ###### 5. Re: Calc field - plot bar chart

I use Analysis -> Percentage by cell

worked, thanks

• ###### 6. Re: Calc field - plot bar chart

Cool

ZZ