Is that possible to customize the time scale text?

BruceSonos
BruceSonos
in Modeling

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.

image.png

Thank you

Best Answer

  • lokeshm
    lokeshm
    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.

    image.png
    image.png

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

    image.png

    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

  • AjayM
    AjayM

    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!

  • BruceSonos
    BruceSonos

    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?

  • devrathahuja
    devrathahuja

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

    image.png



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

    image.png


    Hope this helps! :)

Categories