Skip to main content
Solved

Report builder to support matrix report type.

  • June 3, 2021
  • 3 replies
  • 56 views

narayanan_s
Forum|alt.badge.img

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.

Best answer by rakesh

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.

3 replies

kevin.olayta
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️
  • June 3, 2021

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


rakesh
Forum|alt.badge.img+2
  • Lets put your data to work!
  • Answer
  • June 4, 2021

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.


narayanan_s
Forum|alt.badge.img
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • June 4, 2021

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