nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is that possible to customize the time scale text?

BruceSonos

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

Accepted answers

lokeshm

@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.

All comments

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

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?

lokeshm

@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.

devrathahuja

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! :)

Quick Links

Can you help?

Unanswered questions

Questions related to Charts
Hello All, Is possible to Data label colours based on Legend? By default the Axis in ANPALAN steps up by 2.5K, how to manually adjust? Data labels for all legends is not displayed, possibly due to size, how to move the labels TIA
Reverse Lookup for a List to List Mapping (more than one mapping)
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Connection Problem with Excel Add-In Series 4 - No Customer
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…