Table Pivot/ Graph

[#1]

Hi! I create a pivot table where I count the number of days between two dates in a new field called “Days”, with a data selection.

I’d like to:

1)      1) Visualize the total of values of these fields in my table. How can I do it? Is a format data issue?

2)      2) Create a histogram with the total of each “Days” field in records of my pivot table, only where year is 2013. Maybe should I change the expression used in my pivot table to visualize the total of these fields?

Can you maybe help me with the example attached please?

Thank you for any help you can provide in this situation.

Regards,

Andrea

[kaushiknsolanki]

Hi,

     Do you mean that you want to count the numbers of Days between the End Date and Start Date?

     If yes then kindly use below function.

     Interval(EndDate - StartDate,'D')

Regards,

Kaushik Solanki

[#3]

hi

The Networkdays () returns the number of working days (Monday-Friday) between and including StartDate and EndDate

networkdays ('2007-02-19', '2007-03-01') returns 9

[#4]

hi

try this

=daystart(Date#('2/11/2013', 'DD/MM/YYYY')) - daystart(Date#('1/11/2013' , 'DD/MM/YYYY'))

[er_mohit]

See the attached file

[#6]

Thank you for your help!

But I don't know how to create a histogram based on the total data calculated in my "Days" fields in the pivot Table.

I need to use this expression with these selections, but it doesnt work. Maybe I need to use/add another function in this expression to be able to create a histogram. Can you help me pls?

I really appreciate any help you can provide.

Regards,

Andrea

[#7]

Can anybody help me to create a histogram with the total "Days" field of my pivot table pls?

I really appreciate any help you can provide.

Regards,

Andrea

[#8]

Can anyone help me pls?