Joined: 17 Oct 2012
Online Status: Offline
Posts: 24
Topic: Most Difficult Chart Posted: 21 Nov 2012 at 6:03am
Hi, guys!
I need to make a histogram chart, the most difficult chart. hahaaa
Well... I can't imagine how I can do this chart or how I can do the query...
Look at my situation...
I have missions with many columns, two of these coluns are the beginning date and ending dates. The date that a mission begins and the date that a mission ends. Okay?
For my histogram chat, I need to count the quantity of missions that exists in an interval of dates.
For example...
From 11/01 to 11/10 I have 5 missions...
From 11/11 to 11/20 I have 34 missions...
etc... etc...
Thanks, guys!
My time is over, tomorrow I'll back. Thanks again!
Joined: 06 Aug 2012
Location: United States
Online Status: Offline
Posts: 75
Posted: 23 Nov 2012 at 5:53am
Create formula for how you need to calculate intervals of time: Formula: Count of machines Add Chart: Data Tab-> On Change of -> Add the formula/s to get the required time-frames you need
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
