How the weekly trend by calculated in Line chart

hacktd
Mega Guru

I want to know how the week is calculated when using the "Week" option in the Trend by because I want to create another field which have the same behavior and same calculation then I will use that field for chart pivot table next to this line chart

hacktd_0-1779762521364.png

 

2 REPLIES 2

AndersBGS
Tera Patron

Hi @hacktd 

 

not sure what your asking? It’s just a date / time field where trend by week according to your instance configuration.

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @AndersBGS , thanks for replying the post. My intention is to mimic the way the chart get the current week number of the year, examples: from May 25, 2026 to May 31, 2026 will be week 22 and I would like to know if the chart has the same calculation.