Is that possible to customize the time scale text?

Users export forecast report every day, they are wondering if the time scale here e.g. "Week 1 FY25" could be "Week 1 FY25 (2024-09-29)" which add a START date of this week, otherwise they have to manually add it in the excel file.

Thank you

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

Best Answer

  • Answer ✓

    @BruceSonos create system module with weeks as dimension and use the formulas to create your custom week name . In this case I have created like this.

    Now create a Custom list and add Weeks dimension and import Combine line item into your list .

    Now you can use this list in the module to show your reporting. Refer the week data from the time dimension module by using lookup of Week mapping . Hope this helps.

Answers

  • Hi @BruceSonos ,

    You can't do that with native time dimension unfortunately. You will have to introduce custom time dimension (a numbered list preferably) for the reporting/export purpose, to achieve dynamic renaming of time items.

    Cheers!

  • Hi @AjayM

    Thank you for your reply, regarding the custom time dimension you mentioned, could give me a high level guidance? How could I apply it for the reporting/export purpose?

  • Hi @BruceSonos ,
    You could use the label option of week commencing instead to get the start date-



    The time dimension across the model would look like this in that case-


    Hope this helps! :)

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In