Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Fist of all thanks for the continuing help that everyone is giving.
im trying to write a expression logic,
what i want to put is sum all time where taskname = x and y and z
so far have tried sum (time) and TakName ='Amends', but i dont get nothing.
then i want to show this as top ten.
can you help please
Regads
T
Hi,
Try this:
Sum(<1{[TasName]={"x","y","z"} >} Time)
You can look for "Set Analysis" in help for more details.
JV
BI Experience | A place to share our Business Intelligence experiences
Hello Tyrone,
to achieve this, you would need to use Set Analysis within the Sum(time) calculation.
I believe this would work for you SUM({1<TakName={'Amends'}>}Time)
This means take a complete set within the sum of time, where TakName=Amends. 1 means the whole data set in this expression.
The sorting can then be achieved in a chart for example, using Y Value descending
Hope this helps. Please mark as answered if this does help.
Thanks
how do i write that out?
I am not sure what you mean by this sorry, but this SUM statement would be used as the expression itself. I understand you want to use this for example in charts, so this would be the expression used for the chart itself.
You need to put this in an expression in a chart. Or a text box... Do you have any knowledge of QV? If you want you can attach your app so we can work on it.
JV
BI Experience | A place to share our Business Intelligence experiences