Skip to content

feat(docs): add percent_rank() and improve window functions documentation#350

Merged
javier merged 3 commits intomainfrom
vi_win2
Jan 28, 2026
Merged

feat(docs): add percent_rank() and improve window functions documentation#350
javier merged 3 commits intomainfrom
vi_win2

Conversation

@bluestreak01
Copy link
Copy Markdown
Member

Summary

  • Add documentation for the new percent_rank() window function (questdb/questdb#6712)
  • Comprehensive improvements to all window functions documentation for better human and LLM comprehension

Changes

New Content

  • percent_rank() documentation with syntax, description, use cases, and examples
  • Ranking functions comparison table showing differences between row_number, rank, dense_rank, and percent_rank
  • Practical use cases for all 14 window functions explaining when and why to use each

Documentation Quality Improvements

  • Added return types to all function signatures (e.g., double, long, "same type as input")
  • Added supported data types for aggregate functions (short, int, long, float, double)
  • Updated keywords and descriptions in frontmatter for better searchability
  • Added note about unsupported functions (ntile(), cume_dist())

Example Fixes

  • Updated all examples to use TICK expressions ('[$today]') instead of today()
  • Fixed column names to match demo schema (amount instead of volume, BTC-USDT instead of BTC-USD)
  • Added timestamp column to all SELECT examples for consistency
  • Added demo tags and WHERE filters to all runnable examples
  • Fixed VWAP example CTE reference

Test plan

  • All SQL examples validated against demo.questdb.io (34 queries tested)
  • yarn build succeeds
  • Preview server renders correctly

🤖 Generated with Claude Code

…tion

- Add documentation for percent_rank() window function (PR #6712)
- Add practical use case explanations for all window functions
- Add return types to all function signatures
- Add supported data types for aggregate functions
- Add comparison table for ranking functions (row_number, rank, dense_rank, percent_rank)
- Update examples to use TICK expressions ([$today]) instead of today()
- Fix column names to match demo schema (amount instead of volume, BTC-USDT instead of BTC-USD)
- Add timestamp column to all SELECT examples for consistency
- Add demo tags and WHERE filters to all runnable examples
- Add notes about unsupported functions (ntile, cume_dist)
- Update keywords and descriptions in frontmatter

Co-Authored-By: Claude Opus 4.5 <[email protected]>
@github-actions
Copy link
Copy Markdown

github-actions bot commented Jan 28, 2026

🚀 Build success!

Latest successful preview: https://preview-350--questdb-documentation.netlify.app/docs/

Commit SHA: 156e858

📦 Build generates a preview & updates link on each commit.

bluestreak01 and others added 2 commits January 28, 2026 16:45
Include EMA and VWEMA in the heading to make it more discoverable
in the right-hand navigation.

Co-Authored-By: Claude Opus 4.5 <[email protected]>
@javier javier merged commit 706943d into main Jan 28, 2026
1 of 2 checks passed
@javier javier deleted the vi_win2 branch January 28, 2026 17:40
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants