Report builder to support matrix report type.

3 replies
86 views
Translate All

Current report builder supports summary report but if we could include matrix as one among report type would be of help. For Instance, to report number of success plans per "types" for fiscal year per month.

Now that I could achieve via group by for count of success plans but not split based on year or month. May be in coming days, if report builder has more option on report types would be of great assistance.

rakeshAnswer

Lets put your data to work!

Hi @narayanan_s ,

I think we can achieve what you are looking for with Pivot. If you add Type and Month (maybe its created date) to group by, we can show the data you ask. If you pivot on the Month, you can have one column per month.

Let me know if this helps.

kevin.olayta

Contributor ⭐️⭐️⭐️

Must have!! Hopefully if this is possible in Horizon Analytics, that would be great. :grin:

Translate

rakeshAnswer

Lets put your data to work!

Hi @narayanan_s ,

I think we can achieve what you are looking for with Pivot. If you add Type and Month (maybe its created date) to group by, we can show the data you ask. If you pivot on the Month, you can have one column per month.

Let me know if this helps.

Translate

narayanan_sAuthor

Contributor ⭐️⭐️⭐️⭐️⭐️

Hi @rakesh , Yes please you got it right. I did see the matrix after applying pivot on a field. Thanks!

Translate

Narayan

Didn't find what you were looking for?

Sign up

Welcome to the Gainsight Community