175578 - no subject - hi all,\nI have a question about the fil

eaglez over 8 years ago

hi all,
I have a question about the filter when using "getportalreportdatasubset".
we try to convert a portal report to tempo report.

In portal report, we show process region, process status, and the count , which is group by region and status.
I know we can create a region filter to filter the portal data.

but is it possible to create a time filter so that we can run the report between certain dates in this case?

time filter can work in portal report side. however, in tempo report, I don't know how to make it.

does anyone know this? thank you very much.

Discussion posts and replies are publicly visible

0 Sean Kim
Appian Employee
over 8 years ago

Just to clarify, are you saying that you have a portal report that you are converting to a tempo report (SAIL report) and you are trying to create a filter that will generate a report between specific times?

What version of Appian are you on?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tom Ryan
Appian Employee
over 8 years ago

Consider using the out of the box function a!queryProcessAnalytics() instead:
forum.appian.com/.../System_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 eaglez over 8 years ago

Hi Sean, yes, i'm trying to create a filter that will generate a report between specific times on tempo report side.
i'm using 7.9.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sean Kim
Appian Employee
over 8 years ago

Please refer to Tom's post on the a!queryProcessAnalytics function. You can pass a query as a parameter to the function where you set your own filters. You can also set filters with a!queryFilter in the function. As long as you have a field in your table noting times for each entry in the data store, you can create a filter or set of filters to specify what you would like returned from the function based on time
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel