The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Rianne's avatar
Rianne
New Contributor II
2 years ago
Solved

Graphs x-axis tabels - Date Time Scale Options

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...
dashboards
Reports
  • JackLacava's avatar
    JackLacava
    2 years ago

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

     

     

     

     

aelmehelmi's avatar
aelmehelmi
New Contributor II
2 years ago

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!

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

Dashboard Advanced Charts are a bit of a black art, I'm not sure... I suspect it might have something to do with how much space the chart decides is available, reacting to smaller areas by collapsing periods. Maybe try expanding the horizontal space dedicated to the chart and see if it changes.

There might be something more about it https://amzn.to/3YCjVI6 but I honestly don't know.