Reports

Hi, I have a requirement where an excel report needs to be generated as part of a export functionality. This excel report should have Header, Body (to be extracted from database) and Footer contents. I am using Export DSE to Excel smart service to generate the extract using Header and Body contents. I am having a tough time in populating the values for footer. Sample of the expected excel report is provided below. Here, Generated By and Generated On along with its respective values (xxxxx and yyyyy) are the footer details that should be available in the excel report when it is generated. Please note that Generated By and Generated On is just an example that I have provided here. It can be anything based on client's requirement which needs to be populated for each excel report. How can I achieve this requirement ?  Regards, Deepak

Hi, I want to be able to unselected all the labels that appears in the legend by using a button or any other way. I do not know how to have access to the variable that store a value to know if the label has been selected or unselected. For example, in the first picture there is only 3 label selected, so the graphic show the 3 data lines, every one related to its own label. In the second one, one of the label has been unselected, so the data related to this one does not appear in the graphic. I would like to know how to have access to this parameter so I could make this change without the needing of clicking the label directly. Thanks in advance. PS: here the piece of code that define the linechart, if it is helpfull. a!lineChartField( label: "Forecast", labelPosition: "ABOVE", categories: { union(local!data.date, local!data.date) }, series: { a!forEach( items: union( local!data.consumable, local!data.consumable ), expression: { a!chartSeries( label: fv!item, data

Hello All, I recently created a process report , wasn't able to access SAIL functions like tp!name, tp!assignees. I get a warning improperly scoped variable Was suspecting it to be because of the report type value. I don't remember which one I selected from the below screenshot ( Process model, Process, Task) Question: Where i can see the value of the report type for the already created report and is there a way to update it ?

The no.of.tasks is being displayed the same times as the no.of members in the group. For eg- I am having  a group with 3 members who will be reviewing  a particular task, i.e. for 3 same process IDs i have 3 different task IDs, because of which when i am displaying it in the UI, its showing 3 same tasks where it should have been 1. How do I deal with this problem?

Not able to fetch the top 3 most visited parking spots for a respective month. any suggestions

I'm trying to filter my task report according to either the process, name or created by field. But it's not returning any processes with these exact names. Can I filter the fields like this, for example, the process name is JT Create Incident, but can I reference only Create Incident? And with the name it changes everytime from Approve Incident to Attend To Incident. Can I just reference "Approve" or "Attend To" or should it contain the entire name / process name?

Not able to fetch the top 3 parking locations for repsective month. kindly help

Not able to fetch the top 3 most visited spots for a repective month with below mentioned code. Kinldy suggest { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VP

I am not able to fetch the top 5 most visiting spots for respective month. { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-45ca-

I want to show only top 5 secondary grouping categories for respective month. { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-

I need to show only top 5 most visited places for a month but i am stucked at this point. below mentioned is the code that i used to work out till now: { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType

Hi,  I have created a process report.   I was able to see the list of the task assigned to the group in the report  but I wanna use this report in my interface to allow the supervisor group to approve the leave. but I encountered the error message as  Empty context passed in for report LM Supervisor Task Report [id=4256]. (APNX-1-4156-000)] anyone can guide or teach me how to do ? 

I'm facing the priority changing of a process and task to others different from 0,1,2 (low, normal, and high) priorities, is any way to create others like "critical"?, or if there exist others, where can I see them?

Hello, I have a process model that is using execute Process Report to retrieve data on task metrics and store in the database. We are seeing an intermittent error where data is not being retrieved into process variables. I thought this may be a timing issue, but no data is being retrieved when the model is rerun and the underlying process report displays the required data. Are there any system logs that can be queried to help me identify the root cause of the issue?

i'm trying to create a process report report type task , context tasks assigned to group inside the report i set the required group as a context but i wasn't able to see list of tasks of that group, so please guide me what is missing

How to display pie chart between 2 dates?

I need to create a pie chart from the output of multiple expression rule. How can this be done?

Hi All, I am trying to create one expression rule to get count of records created by  Tester_Group. In table, we have CreatedBy column. Requirement is to display the count in UI by using a!gaugeField(). Please help with some ideas. Regards,Sandeep

In a column status I have 6 values repeated, but in pie chart I want to show 3 values percentage. How to do this?

How To Remove Unwanted fields in pie chart.

I want to ask about this function =task_avg_completion() as its output is not compatible by its description when I try to implement it in the process report. I am targeting to return from this function in my report the average completion time of a task per all process instances of a process model which is expected to be the same for all the process instances but the average completion time is different from a task to another inspite it is the same task name as shown in the following pic

How to save the accepted ,reject and inprogress status values to make a pie chart of it?

Hi All, I have created a Process report for the viewing the task but i'm facing  this Error in site landing page, but in the interface looks fine. a!localVariables( a!sectionLayout( contents: { a!gridField( label: "Supplier Tasks", labelPosition: "ABOVE", instructions: "A list of all tasks for the Supplier group", data: a!queryProcessAnalytics( report: cons!IA_SupplierTaskCons, query: a!query(pagingInfo: fv!pagingInfo) ), columns: { a!gridColumn( label: "Name", sortField: "c0", value: a!linkField( links: { a!processTaskLink(label: fv!row.c0, task: fv!identifier) } ) ), a!gridColumn( label: "Status", sortField: "c5", value: a!forEach( items: fv!row.c5, expression: if( fv!index = 2, "

I have changed the task display name to dynamic. But it is not showing in task report. How to do it?

How to group the reports in Tempo Reports tab. Need to create links in left panel and based on the selection, list of reports should display in the right panel. Please let me know