matrix table/report

Pat VachonPat Vachon Member ✭✭
edited June 25 in Ideas
I know I could use SF matrix report, but it would not be responsive to any filters I set and don't like how it would look out of place on a skuid page.




8
8 votes

Under Consideration · Last Updated

Comments

  • edited July 2019
    +1! 
  • David GigerDavid Giger Member
    edited June 25
    Hey Pat,

    A component would be great for this! 

    But in the mean time you could create something custom.

    I found some good looking JS libraries: http://nicolas.kruchten.com/pivottable/examples/ and http://orbjs.net/ which you could easily integrate. Have a look at them and tell me what you think.
    If you need help setting that up, just let me know ;)

    Cheers
  • edited July 2019
    Yep, the pivot table was used before with skuid: https://community.skuid.com/skuid/topics/pivot-table-like-component

    To lazy busy to try to integrate it :p
  • Pat VachonPat Vachon Member ✭✭
    edited November 2016
    I don't need this that much atm.
  • Joe LagorioJoe Lagorio Member
    edited December 2016
    I don't mean to intrude, but would you be able to help me set this up, David? 
  • Brayden SmithBrayden Smith Member
    edited January 2017
    +1 A tutorial on this would be awesome
  • edited January 2019
    Any update on this idea. We need this kind of report for scheduling. Can anyone help me or guide me to integrate this solution  http://nicolas.kruchten.com/pivottable/examples/ to skuid ?
  • Jeremy IversJeremy Ivers Member
    edited April 2019
    A workaround using the SFDC Lightning Reports is to use the URL Filtering.

    https://help.salesforce.com/articleView?id=reports_filter_url.htm&type=5

    Save a report with the filters you want to use. Then go to the report and copy the URL. You only need the part from /Lightning onwards. Then you add the filter number and Skuid merge syntax field. e.g 

    /lightning/r/Report/{{sfdc report id}}/view?&fv0={{skuid merge field 1}}&fv1={{skuid merge field 2}}

    I use either a table button or a button set and set it to open in new tab.

    This won't work in all use cases and forces users to go away from the Skuid page.


     It would be awesome if Skuid could release a component that can do this within the page. 
  • Rob HatchRob Hatch Skuad ✭✭
    edited April 2019
    There are two ways to get some of those matrix features in Skuid today. 

    1. Use decks and context to move data into columns.   This works for things like tasks by day.   
    A first model provides all day values (a UI only model,  or an aggregate model on an object guaranteed to have values for all days).  Then a deck on the task model uses context to show data in the right "day" column.   Adjust the card size (and padding) so that all days fit on one line and don't wrap.  Use a second master model if you want to have a vertical dimension (say owner or category). 

    2. Use a template grid.   If your data is static . (like opportunities by quarter) and you can make an aggregate model that guarantees data will always be in the same row - you can use global merge syntax in a template to push data into the appropriate position.  If your model guarantees that row 1 will be Q1, row 2 will be Q2 etc - then use syntax like {{$Model.oppsAgg.data.1.sumAmmount}} to put the Q2 data in the right column. 

    Neither of these are as flexible as Nikolas Krutchen's js plugin,  but we've had uneven results trying to get that to work in Skuid.  Ann our examples are currently busted. 

    Have fun. 
Sign In or Register to comment.