[AnalyticalTable]: Sticky first n columns, group header and table footer

[LukewenSAP]

Is your feature request related to a problem?

No.
Currently, the AnalyticalTable does not support stick/frozen first n columns, group header and footer, and these are new requirements from UX design and customer's requirement.

Describe the solution you'd like

Can we add 3 features for AnalyticalTable:

1. Sticky (frozen) first n columns when scroll to right
2. Support group header
3. Support footer

Here is screenshot from UX design:

Describe alternatives you've considered

No response

Additional Context

No response

Organization

SAP

Declaration

• I’m not disclosing any internal or sensitive information.

[Lukas742]

Hi @LukewenSAP

Unfortunately, implementing these features is challenging due to the current structure of the AnalyticalTable and would require a complete refactoring of the component, which we don’t have the capacity to tackle in the foreseeable future.

[LukewenSAP]

Hi @LukewenSAP

Unfortunately, implementing these features is challenging due to the current structure of the AnalyticalTable and would require a complete refactoring of the component, which we don’t have the capacity to tackle in the foreseeable future.

Hi @Lukas742 ,
Sorry to heard that, and I will let UX and PM know.
These features are important to compensation and variable pay worksheet table, the table will be very big and could be configured by customer.
So if AnalyticalTable cannot be enhancement to support these feature in the foreseeable future, do you have any suggestion to us as an alternative？

[LukewenSAP]

Hi @Lukas742 ,
I synced with our UX and PMs, they want to raise priority, and want to learn from you team: can you give us a ETA even though it is in the foreseeable future?

Thanks!
Luke Wen

[Lukas742]

Hi @LukewenSAP
we talked about this topic internally and decided to revisit it early next year. While I can’t promise any results yet, we’ll try to create a PoC and see how it goes. We’ll update this issue once we have more to share.

[LukewenSAP]

Thanks @Lukas742 for your kindly updating!
I will sync these information to PM and UX so that they can re-schedule the plan.

Thanks!
Luke

[steffektif]

Hey hey

we're also in the need of this feature for a SAP Signavio DMN use case. I can provide more information if necessary, but for now, we have made a commitment to an external customer to deliver something that would rely on this functionality by the end of Q2. We are still in the investigation phase, but this feature would make us use the analytic table most likely.

On your board I see that this issue is planned for delivery on Q1 this year, is this information correct?

Best

Stef

[Lukas742]

Hi @steffektif

we plan to finish an initial experimental draft (PoC) of a new table implementation that includes these features at the end of Q1. (see this comment) Apart from that the initial feature set will still be limited.

Also, since it will only be a draft, the table will be in experimental state, therefore API changes might occur in between versions. A stable release is not yet on the horizon, as we can't assess how many resources we can put into this topic.

[steffektif]

Hey Lukas, thanks for the quick response.

Just to avoid confusion, this will be a new version of the current analytic table not an entirely different table, right?
Will this PoC / draft version be made available publicly?

[Lukas742]

@steffektif sorry I should have been clearer.

The current implementation of the AnalyticalTable doesn't allow implementing the requested features without a complete rebuild of the table. Due to limited capacity this is not feasible for us, as these features would require a huge refactoring of the component which in turn requires a lot of testing to not break existing implementation. Also, the underlying library (react-table) we use to create the table had a major update a while ago, which is unfortunately not compatible with our API, that's why we're still stuck on v7 which isn't maintained anymore.
That's why decided to create a new table, while still maintaining the old AnalyticalTable component.

So, to answer your questions, we won't implement these features in the AnalyticalTable component, but in a new component. A first draft should be available at the end of Q1.

[steffektif]

Thanks Lukas!

So that means a new experimental version of the analytics table based on v8 of react table is suppose to be released at the end of Q1/25, it will be experimental but in theory we could start using it, right?

[Lukas742]

@steffektif Correct :)

[Lukas742]

Hi all,
unfortunately, we have to delay the initial draft release of AnalyticalTableV2 (working title) as our priorities shifted in March and I haven’t had time to work on it since. The new ETA is now the end of Q2.

You can follow the progress here.

[LukewenSAP]

Thanks, @Lukas742, and everybody's efforts and updates.
I think it's OK for us to be delayed because our project has been shifted as well for some reason.
Will keep an eye on the progress #7134 and keep in sync with UX and PM.

Thanks!
Luke Wen