100749 - no subject - I am trying to create a simple report of

Keith over 11 years ago

I am trying to create a simple report of tasks that are late. I have it created. I created a filter set for the task status so you can see completed, assigned and accepted statuses. I want to also have a choice of Active. I have tried and tried and tried to make this happen and everything I try is not working.

I even created a rule with: called activeTask with =if(ri!taskStatus="Active",1,
if(ri!taskStatus="Assigned",1,
if(ri!taskStatus="Accepted",1,0)))

When I put try : =rule!activeTask(task_status()) I get all 0s in the report and no 1s.

What am I doing wrong?

I tried the if expression without a rule and it would not produce desired result either.

I don't want to be negative - but - simple things like this cause people not to want to learn how to do reports on their own.

...

Discussion posts and replies are publicly visible

0 Keith over 11 years ago

I got task_status from the task report under Metrics.
If you chose this and have the type being Task Status you will see, Accepted, Assigned, Skipped, Aborted, Completed etc for the task status. I have a filter for Accepted, Assigned and Completed. I want to have choice for Accepted and Assigned. A manager wants to see what tasks are late.
I am trying to combine two task status values so I can filter on it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jesse.triplett
Appian Employee
over 11 years ago

I see, the OOTB rule.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jesse.triplett
Appian Employee
over 11 years ago

I see, task_status() is actually an integer on the back end. Please follow the statement below for the mapping ("Assigned" is 0, "Accepted" is 1, etc)

displayvalue(
ri!status,
enumerate(13),
{"Assigned", "Accepted", "Completed", "Not Started", "Cancelled", "Paused", "Unattended", "Aborted", "Cancelled By Exception", "Submitted", "Running", "Error", "Skipped"},
""
)

This expression was taken from the documentation
forum.appian.com/.../Task_Report_Tutorial
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jesse.triplett
Appian Employee
over 11 years ago

So your rule should be a statement like
if(contains({0,1,10},ri!taskStatus),1,0)
Where the {0,1,10} array is whichever statuses you want to associate with 1
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Keith over 11 years ago

Here is the good and bad news here. I changed the rule and then tried the report and it did not work. I changed the report to have the contain statement in it without the rule and the report works the way I want it to. The rule is not needed now.

Thank You Jesse for your help.

I will have to check on the documentation what the status numbers mean.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jesse.triplett
Appian Employee
over 11 years ago

Glad to help, sorry for the confusion
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel