Reports

hi,  I have built a bar chart with a simple measure of SUM of time but when I put the labels I see a value like 47.9499999999999996 I have checked the issue is not with data.. I do not have that kind of data. I have a solution that I round off the the time taken, store it in another variable and use it for SUM and it works.. but I cannot individually round off the time field.. the overall data deviates a lot. All I need is to round off the above data to 47.95 .. when I see the expression generated by the MEASURE function on the chart I see Is there a way i can modify this expression so that it returns a value upto 1 or 2 decimal places.. I tried using round func in this expression but that's not working thanks much  jaideep  

Hello, I am trying to incorporate a milestone report that links to different tasks in a process model: a!milestoneField( links: { a!processTaskLink( label: "Tasks in progress", task: 536875568 ), a!processTaskLink( label: "Tasks in progress", task: 3808 ) My problem is that the task report ID changes every time the process is run. Is there a way to query my process report for the dynamic task ID? Thanks,

Hi, I have a pie chart that displays the 'label' & 'data' outside the pie chart. I want to display the 'label' outside the pie chart and the 'data' inside the pie chart. Is there a way to do this?

Hi everyone, How to query in appian Not between in these date from oct 1 to oct 5, I would like to show data that not between on these date?

I need to get process tasks by groups of particular appilication , Thus if I have a process report for L1 group show below . while fetching thoese report to interface i am getting Error  The error says passing empty values . the cons i am calling for process report is attached below , what changes should i do now?

In column chart the label above the column shows a number. The problem is for the empty one it shows zero and I want it to show nothing for Zero. How to do that.

Hi All, We've a process which is started via webAPI and has a node which uses QueryProcessAnalytics to query the process report to get a few details. This node where it fetches the data from Process Report is  not working/not returning results when running the node as the same user as process initiator(in this case , service account used by webAPI), however, it works fine when changing to execute as user (process designer). We checked the security of the process reports and the parent folder and it has the service account group with Viewer permission.  The only difference we see is the service account is basic user and the process designer user is system administrator. Any pointers to why query process analytics is not working when called via webAPI with a service account?

Hi Community,I am trying to query form Active Task assigned to users in my application from a Process report. I was not able to create a filter for the same to check assigned tasks for selected users.= a!queryProcessAnalytics( report: cons!I_MY_OPEN_TASKS, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "c0", operator: "includes", value: ri!taskName ), a!queryFilter( field: "c3", operator: "between", value: { ri!assignedOnFrom, a!defaultValue(ri!assignedOnTo, today()) } ), a!queryFilter( field: "c4", operator: "in", value: ri!assignedTo /*issue at this filter*/ ) }, ignorefilterswithemptyvalues: true() ), pagingInfo: a!defaultValue( ri!pagingInfo, a!pagingInfo( startIndex: 1, batchSize: -

how to create end user to enter the insurance number and get a report. 

Hi All, I have created a task report where my initial sort is task_id in descending and configured in Site .Whenever I load the task report, it shows me the grid in a correct manner with task_id in descending order. I am also showing a link where I am calling the record action to create a new task. The task consists of 5 milestone with active chaining and all has back button except the 1st milestone. When the user clicks the "next" button in 1st milestone then we generate task id by writing in DB. Not working Scenario :  From task report, the user clicks the link(create new task link),he completes 1st milestone data & click next ,goes to 2nd milestone. Then from 2nd milestone if the user goes back and comes to 1st milestone, then user tries to navigate, so they just click the task report tab . Issues : 1. Now the current task id is not visible in the task report grid 2. The sorting of task_id in task report is totally collapsed. Until this sorting was working p

 I have datas saved in Appian DB , I want to export all the datas into an excel and store in into a shared location and the datas need to be deleted after exporting to excel .And this process need to be performed on the starting of every month . Any suggestions how  to achieve this . 

Is process  & task reports the component that requires extensive coding ? Is there a component available to make it easy for moderate techies to create great reports low-code way 

Hello. I have multiple Reports that are Task Report Types by process model. While the report itself returns data, a!queryProcessAnalytics() returns no value for data. I'm not sure how to make or update the connection. Thanks.

I have created one process report and then I fetched the process report data in grid by using a!queryProcessAnalytics function. then i have created link for user to complete the task(for link i have used a!processTasklink function) . when i click on the link it shows this error, the code for process task link, please suggest a way to solve this error  and Is their any alternate way to do it? .

In the function a!queryProcessAnalytics the sort field in pagingInfo can contain multiple sort field without conflicting the result data correctly? I have two fields that are to be sorted together but it seems the results are conflicting because of it.

Hi while making a column chart by make and category i can see the make detail names but my category names just appear as numbers  can somebody help me as to how to get this fixed

Hi all, I have created process report type as context type -Tasks assigned to group for the lists of tasks assigned to group(abc,mno,xyz). and when I tried to test through the a!queryProcessAnalytics(report:"my report") it is throwing the error that "Empty context passed in for report sg1 [id=46716]. (APNX-1-4156-000)". even though I have given the report context with list of groups. Can Anyone suggest on this ?

Need to build a Interface to shows all users activity on tempo reports

Hi all, I want to display all the tasks which are assigned to xyz groups.I have used process report for the same and also getting the task lists which are assigned to that xyz group and also getting same task more than 4 times for the same assignee.  Can someone suggest on the same? Thanks in advance.

hi I have process report that shows me all processes. I would like to get exact start, end and duration time. As our global settings is us I've used text function to get time in format  dd-mmm-yy hh:mm:ss and milliseconds. Problem is that sometimes the END TIME is before START TIME and it does not sum up (Start Time + ProcessDuration = End Time).  Please advise how to properly capture process completion time and it duration. There are no tasks in this process. Appian version 20.4 Start time = pp!starttime with text function to format it. Process Duration = =process_duration() End Time =text(process_completion_time(),"dd-mmm-yy hh:mm:ss") & "_" & milli(process_completion_time())

Hi Appian folks, Is it possible to split the data of a column and then perform aggregation over that data?  We have a requirement where we have to display data in both categories in a pie chart but on DB level, that data is multiple in nature, stored with a semicolon. The DB design is correct but aggregating it in a report has sort of became a blocker now.  Data for a row looks like: Category A;B;C Pie charts have three categories: A, B & C

Hi, can we use task report (a!queryProcessAnalytics) to show the read only grid by fetching data from db? 

Hello, I want to create a report using column chart that shows the following conditions(I am done with the first 2 conditions), I'm stuck on the last 2 conditions, could someone help out? Requests that are closed by agent Requests that are open by agent Average time agents are taking to complete their tickets Average time each department is taking to complete their tickets. 

HI Team, I am using the site_usage.csv to generate report for business. There is one "Action" tab which contains  View Site Task ReportView Process Task FormSubmit Process Task FormView Site Action Start FormSubmit Site Action Start FormView Site Record ListView Site ReportView Site Record ViewView Site Related Actions ListSite Record List Search Can anyone translate this to layman terms which business can understand like which one stands as DB "transaction" and which one is "Read-only" OR anything meaningful.  Thanks Bihitak

Getting the error "An interface with rule inputs cannot be saved as a report" when adding interface to report