matrix table/report

Pat Vachon
Pat Vachon 💎💎💎
edited June 25, 2020 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.




9
9 votes

Under Consideration · Last Updated

Comments

  • Pablo Martinez
    edited July 1, 2019
    +1! 
  • David Giger
    edited June 25, 2020
    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
  • Pablo Martinez
    edited July 1, 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 Vachon
    Pat Vachon 💎💎💎
    edited November 17, 2016
    I don't need this that much atm.
  • Joe Lagorio
    edited December 13, 2016
    I don't mean to intrude, but would you be able to help me set this up, David? 
  • Brayden Smith
    Brayden Smith ✭✭✭
    edited January 13, 2017
    +1 A tutorial on this would be awesome
  • Toms Vineeth John
    edited January 7, 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 Ivers
    edited April 15, 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 Hatch
    Rob Hatch 🛠️ 
    edited April 17, 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. 
  • CRMF Woj
    CRMF Woj ✭✭
    edited June 8, 2021

    +1 - this would be a great addition to the skuid arsenal

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!