Reports

Hi there, could anyone know when configure the "Export Data Store Entity to Excel"/"Export CDT to Excel" smart service, "Save in Folder" can only be set as the folders in Appian platform. Is it possible to export to the application user's local computer? Best regards, Lin

We have designed a process report to display tasks. We have added 2 process models in the report. The tasks of one process model are showing up in report but the other one is not showing up. But the task is showing up in tempo.Previously it was working fine for both. I am not able to find any reasons for this. Can anyone help on this?

Hi,I want to create a process report in which I want to capture the process error information in a column , is there any way to do that?

Generate process Report which has process model stats, like process is errored out/completed , if process is errored out it should show the error in the report. Is there any way to achieve this in Appian, As we have a requirement to collect those data , convert to JSON and pass to an external application through WEBAPI?

I am trying to create a text column with properties from the user function inside a process report. I want to create a text field with "firstName lastName". I want to utilize tp!owner or the tp!assignees The user function is suppose to be compatible with reports but when I try to use it doesn't return anything.

 How to Download data to an Excel where a view has more than 150 columns?

Hi, Is there any option to generate below 3d report in Appian.    Thanks in Advance.

Hi all, I want to mimic my grid data in an excel report, the issue is that one of fields that I want to export is set to datetime in a DB and I want it to display AM/PM format in a report. Is there a way to convert datetime field for every cell in that column in a report?DB: Grid and conversion:

Hi team, Is there any way to add personalized tooltip in google chart as it is giving information of the entire column, But I need the information of the hovered slice as shown in the picture. Also is there any way to add personalized colors for the slices? Any suggestions would be helpful. Thanks in advance!!

Hello Everyone, I want to highlight the selected slice in column chart as below (as red color selected slice) on drill down selection. Any suggestions? Thank you in Advance.

Hello Everyone, Can anyone help me with the Purpose of process reports?

Is there any way to export the data which is displayed in bar/pie/line charts defined in an interface data to interface (graphs) pulled from new version of record type. kindly suggest on this.

How to apply Aggregation (grouping) based on condition as like Group by on condition in Mysql? Example: SELECT * FROM `TABLE` GROUP BY ( CASE WHEN `NAME` = 'AA' THEN `COLUMN1` ELSE `COLUMN2` END );

I want to generate a Column Chart from Expression rule which contains query aggregation on two columns , How can I generate a Column Chart for this. Below is the code of my Expression Rule index( a!queryEntity( entity: cons!MBUA_DSE_TESTSITEDATA, query: a!query( aggregation: a!queryAggregation( { a!queryAggregationColumn(field: "site", isGrouping: true()), a!queryAggregationColumn(field: "worktype", isGrouping: true()), } ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: false ), "data", null() ) Below is the code on Interface having Column Chart: a!localVariables( local!myData: rule!MBUA_readChartView(), { a!columnChartField( label: "Column Chart", categories: { "Category 1", "Category 2" }, series: a!forEach( items: local!myData, expression: a!chartSeries(label: "Chart", data: fv!item.worktype) ), stacking: "NONE", show

Hello, I'm trying to figure out how we can set up alerts based on the metrics in our Health Cloud Metrics reports. For example, we're able to see the CPU Utilization metrics to the servers that are hosted in Appian. How can we set up an alarm/notification to alert my team when it hits a 90% threshold?

Hi everyone,  I need to export the data contained in a Read Only grid with variable Data Source, therefore I cannot use the default Export functionality available for Record and entity based grids. My grid can have two sources of data, one being the default columns I have on the report on which it is based and/or one or more columns that users can select with a UI we made. The grid then can have a mix of Report and Database data source. I tried the exportProcessReportToExcel function, but it only works with the data and columns set on the report. I'm looking for a way to export to Excel the whole content of the grid, whether it is an OTB function or a plugin. Thank you very much in advance. 

Hi All, I am creating Process Models, Process Metrics, Task Metrics Reports in the Appian. and then I am fetchiing the data from the report in the process models and using it. My query is what is the data retention period of those reports in Appian. Like how old data it could have and how can we configure this. ? and is it something manages by the APPIAN DB itself or managed by the organisation. if by the organisation than where we can find that configuraiton.. Thanks

When i re-assign task to particular user then the status is still remains to assigned not the accpeted untill that person open the task, is this a functionality or task or a bug?

Hi All, I am trying to make a task report interface. This is a snippet of my report. Here, I just want to ensure that by default when a user lands to this page, they only see their assigned tasks, and only when they click on  the dropdown they should be able to view other task status in the grid such as "Completed" , "Accepted" and "Not started".Here is the snippet of my code, I tried using the local!statusfilter to be just as "Assigned", but that is not working, for now the value is null. Request some help on this!

Hi All, Need a help with this scenario - There is a scenario when a task is accepted by an user. If that user goes on leave or leave the organization and task is locked to this user, how assigned tasks for this user can be reassigned to a group.

I have a view with 11017 records and I'm trying to export this data to csv via Export Data Store Entity to CSV smart service. The issue is that it exports only 11015 records and the file size is around 200KB

Hi Team, Here I want to pass parameters dynamically from Appian to the stored procedure and get the data subset, then export that data subset to Excel. I have created a stored procedure, and when I tested passing dynamic fields and data, I am getting results. Now I wanted to export this data subset to Excel, so I tried using the "Export SQL to Excel" smart service. But I am getting the following error: "The following error was raised by the Export to Excel function: null" Is there any other smart service to export data subsets to Excel? Please advise. Thank you!

Im trying to set specific format for Start Time Column at the process report and data does not show when i set the format.

Hi Techie, Record is getting updating/inserting in the external database however when coming to Record Type, it is failing to sync.Can anyone please look on it. Caused by: com.appiancorp.core.expr.exceptions.IssuedException: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error [evaluation ID = f7383:f3bde] at function a!recordList: An error occurred while retrieving the data for "PEG_CMP Request". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000)

Requirement -  Opened a task link from site, clicked on continue, it went to new task using activity chaining, at this place reload site URL (it is still pointing to previous task URL) giving error - "The Task Could Not Be Submitted" The Task has already been submitted Scenario -  I have a Process Model In which have Multiple User Input Node, each Node are sequentially connected, and activity chain is enabled One task report is created, and this task report is added in an interface with process task link so one can open any intermediate task using this link This Task Report is added in a site object  when we access this site from URL, using task link in interface, open a user input task (we can see here the task URL in the browser) we clicked submit button on that task, it went to next task in that process model, at this place we can see (the same URL in browser as the previous one)  when now we reload this browser URL, it is giving us error,