Reports

Hello folks, I want to create a column chart like the image below, any suggestions?

Hi,     Whats is reports,,records and sites give me a example

Hello Appian Community, We are receiving a request from our customer to track the user's activity inside the application. 1. Track their login/logout timestamp per application per user 2. Track their time spent on viewing each interface per user per application 3. Track their action performed inside the application (clicking button, submitting the form, user input task etc.) Please suggest if this request is feasible. Thanks in advance

I have a requirement where I want to have more than 50 columns in Export to Excel/CSV. Is there any way to achieve it?

Hi!. I had created a report task with user context, but when I test it, Appian give this response  "There was an error querying the Analytics report. (APNX-1-4275-000)". Somebody can help me?   Thanks

Hi Everyone, I have a task report. Basically i need to get total count of tasks for  a logged in user, but i am not getting the correct count. In my task report , one task has 2 assignees. Report looks like below, Task Assignee Task 1 User1;User2 Task 2 User1 Task3 User2 while querying when i apply the filter for "user1" i get only one task but ideally it should have been 2 right? Please help.

Hi,  I am working on exporting a record grid to excel. I am getting an error message while using Export Data Store Entity to Excel Smart Service.  Filters field must be of type QueryFilter or LogicalExpression (APNX-1-4505-019).  I am using a script task to get the values and passing into the filter node input.  What could be the problem here? Can anyone help me with it? Thanks   a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "partNumber", operator: "includes", value: pv!partNumberFilter ), a!queryFilter( field: "supplierId", operator: "=", value: pv!supplierFilter ), a!queryFilter( field: "manufacturerId", operator: "=", value: pv!manufacturerFilter ) }, ignoreFiltersWithEmptyValues: true )

Hello, I am looking for a way to convert an Svg to Appian Document/PDF. I receive the svg code of a chart through a web service and I am planning to show it in an interface with the plugin Interactive SVG Map Component. Is there a way to insert this svg chart in any type of document (PDF, HTML, DOCX) which will then be downloadable? Thank you for your time.

I have this task report and i am getting empty values for the fields shown above . How can i update my portal report with values from process model?

is making reports using stored procedures is good practice or using expression rule ?? which is best and why?

I want to generate this sample report using the export to excel but they include the  column name in the DSE The format of the report will be like this

Can Convert to Excel read the specific row and Column?

I want to export a multiple data using the expression rule, Can export to excel export that data? for example 0001, abcd, ads, sda0002, abcd, ads, sda0003, abcd, ads, sdaTotal of 0003 

How to use dynamic link in pie cart to call a interface(read only grid) ?

Can I use expression rule as data Source of pie chart ?? if yes how to do that??

Hello, do anyone know how can you modify specific query column value to excel file? I want to change the return value ex. amount to 1,000.00 instead 1000 but there's no documentation on how to do that.. I return the database data to "Starting Cell" but I want to modify the format.

Hi there ! So... I've created a bar chart with some custom fields filters. Now, I'm trying to create a validation for 2 date fields, since they're about date interval and I wanna validate if the second one isn't greater than first one, for example. I created some validations on field, using "validations" property. It shows error mesage, but still filter chart's data. Here is the point: I wanna prevent it. Doing a analogy to web development, I wanna prevent the load event. Is it possible ?

Yo ! I'm trying to create a chart (horizontal bar chart, especifically) and, after watch all the videos about it, I couldn't figure out a way to set some users filter. In a grid report it's izi. But, even after set in record type user filters, they aren't avaible for chart report. As far as can understand, a grid is required to add user filter for a chart. Is the correct ? If not, how could I create those filters?

Hi there ! Trying to create a report based on counting register and group by date. So, the result should something like that: Records    Day      10        25      4          26       9          27       25        28       16        29 Looking for a solution, I find out this function that handler month and year, but nothin for day. Is it possible to do that in another way ? Dunno, a workaround using a expression, for example. Thanks anyway for read till here!

I am using a process model to export data from the database to a spreadsheet. I am not using the export in the record type, just to be clear. When selecting the fields using the a!querySelection -> a!queryColumn, this immediately pulls the data and exports to a new spreadsheet, with no way of adding code to process it. If I have a CDT that has, for example, twenty fields, and one of those fields contains an employee ID. How can I, or is it even possible, to use an expression rule that takes an ID parameter, and outputs the actual employee name? There doesn't seem to be a path forward on this. I've looked through the process model, all the different query types, etc., but no way to pull the data, then process that data, before outputting to the spreadsheet. Just to make sure this is clear, I already have the expression rule to process the data, I just have nowhere to do it and if there is a way to do it, I have not found it. Any help will be greatly appreciated.  Thanks.

hey all,  There is one bug that I need to have fixed: Whenever someone opens a request the form does not open anymore in the record tab. Instead the user has to navigate to the tab “tasks”, refresh the window, and only then the form appears. Why is this happening? Instead of opening directly the form here directly :  I have to go to the task tab to see the form itself. Kind Regards,  Victoria

how we can assign task to user on site and where do task save? i dont know if i am asking the right question. Can anyone tell me concept about task s, process report task and related things?

We have a user input task assigned to a group and a user accepts the task, is there a way we can capture those task details to separate table in DB when that task is in accepted state before the task gets completed.

hi everyone. I'm trying to read text from screen by RPA. and save its value to a robotic variable.  for example, read number "203244" and store it. any idea to make that ?

I have a requirement to send consolidated escalation emails. One user can have multiple tasks assigned to him. But requirement is we cannot send individual escalation emails to users as its increasing their mail box volume. So Instead of default task escalation email,  I need to create a consolidated email which will show all the tasks assigned to a particular user in a single mail if task isn't completed within 2 days. I have created a  task report &  I tried using grouping by task owner field  inside queryProcess analytics, but it isn't working , attached code image.I am getting the below error message errorMessage"The aggregation query parameter is not supported. (APNX-1-4203-027)" Please Help Me its Urgent.. TIA