Help with total function

[#1]

I have created a chart which basically has the following values

Date	Customer	Time	% Time Spent
26/08/2013	Epicor	6:30	%100
27/08/2013	Epicor	4:00	%53
27/08/2013	RB	3:30	%47
28/09/2013	Dixon	1:00	%11
28/09/2013	Epicor	2:00	%22
28/09/2013	RB	5:30	%67

The expression for the total time is:

     sum(EndDateTime - StartDateTime) / sum(TOTAL <Date> EndDateTime - StartDateTime)

Which works fine when nothing is selected.

As soon as I select a customer, the percentages changes to be %100.  I assume this is because the expression is going off what is I selected.

How can I change the expression, so the TOTAL figures is the total time spent on each day, irrespective of what has been selected.

Thanks

Andy

I have added the dashboard and the excel file

[Anonymous]

Hi Andy,

Would you care to attach your QVW file?

Cheers,

Antoine

[whiteline · Accepted solution]

Hi.

With set analysis you can modify user selections that is used for expression.

For example to discard customer selection:

sum({<Customer=>}TOTAL <Date> EndDateTime - StartDateTime)

[israrkhan]

hi Fearn:

try Below Expression, May This Help:

=sum({1<EndDateTime - StartDateTime>}) / sum({1<TOTAL <Date> EndDateTime - StartDateTime>})

Khan

[#5]

Thank you for helping but your expression I couldn't get your expression to work

[#6]

Hi

That worked.

Thanks

Andy

[MK_QSL]

=sum({1}EndDateTime-StartDateTime)/sum({1}TOTAL <Date> EndDateTime-StartDateTime)