[table]Advanced Analytics for Table Viz

[kkalyan]

Is your feature request related to a problem? Please describe.
As of now, there is no way to get Day over day or week over week increases (and percentages) in Table View. There is support for Time shift in Bar charts, but its not there in Table Visualization.

Describe the solution you'd like
Table Viz needs to have Advanced Analytics section. This was described and attempted to implement earlier
#2324
#2325

Describe alternatives you've considered
If backend support window functions like LAG, this would be possible.
https://www.sisense.com/blog/computing-day-over-day-changes-with-window-functions/
Some of the backends (like MySQL, Druid) does not have support for windowing functions.

Additional context
Add any other context or screenshots about the feature request here.

[issue-label-bot]

Issue-Label Bot is automatically applying the label #enhancement to this issue, with a confidence of 0.96. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[ktmud]

Could be related #9887

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[junlincc]

@ktmud committed to this enhancement from our end.

cc @villebro

[ktmud]

Hi, @junlincc , I am indeed working on adding per-column adhoc formattting, but advanced analytics isn't planed for the near term (or long term) yet.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[rusackas]

I don't believe there's any current momentum to add this feature to the current Table plugin. I'll close this as a "won't fix" but if anyone is really clamoring for this feature, we should open it in an Ideas thread on Github Discussions and start the proposal there with updated context.