In need of a Pivot table like report

Hello,

I am using an Outsystems Reactive site and I have a need to create a report like shown below.

It is grouped by Company -> Maintenance Type  -> Check status and lists the counts for each check status for the past six weeks.

I have not found any useful examples of how to accomplish this. (Still new to Outsystems)

Any help would be greatly appreciated.

Solution

There is a forge component called Pivot Table for Reactive which may help

Pivot Table - Overview | OutSystems 

Also another one which is an example of using the SQL pivot command

Pivot SQL Sample - Overview | OutSystems 





I did find the Pivot Table reactive component earlier.

I was not able to install it from the Forge because of the "No stable version for your environment" error.
After looking into it more, I was able to manually download the component and install it that way.

This is exactly what I am looking for. Thanks!

Yes there are quite a few forge components that you will get an error like that. 99% of the time it's just because they were built with an older version and just need to be installed manually and sometimes you may have to open them up and fix some out of data references but they are fairly much fine to install.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.