Dear community,
I am working on a graph that shows the daily FX rates.
I am bringing the data in through an SQL Data Adapter and have set up the following settings in regard to the data and what is shown on the x-axis:
Data is shown in days, but the x-axis name are 'summed' to the months.
This works great except for the fact that it writes the month as full. I think it's based on the Time Dimension Description because the date format in the data table is: MM/DD/YYY
As you can see the graph is quite small and the naming takes up a big part.
Does anyone know if it's possible to adjust the sourcing of this naming/description? Maybe to a UD8 TimeDescription member or adjust the description of Time in the graph itself, or maybe through the data table or data adapter?
Thanks in advance!
This led me to some unknown places, so thank you 😉
First, select your axis by clicking on it; then look for the Label ▶ Text Pattern property to set your custom pattern. Click on the ellipsis to open the editor; basically you select Argument, then one of the prebuilt formats, and you can then manually customize it simply by typing in the central area.
The result can be seen below (hopefully - I know it's a bit small).
This led me to some unknown places, so thank you 😉
First, select your axis by clicking on it; then look for the Label ▶ Text Pattern property to set your custom pattern. Click on the ellipsis to open the editor; basically you select Argument, then one of the prebuilt formats, and you can then manually customize it simply by typing in the central area.
The result can be seen below (hopefully - I know it's a bit small).
That is very useful. Do you think I can achieve the same in an advanced chart component?
Tried the following but did not work, when I change the argument type to Date Time the custom formatting works but I get the x-axis showing a 3-month interval, instead of 1 month.
thanks!
