Forum Discussion

Rianne's avatar
Rianne
New Contributor II
2 years ago

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

 

 

 

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

     

     

     

     

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    Just to clarify, is this a BiViewer component or a Report component?

     

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

    Hi Jack,

    Sorry for the unclarity, this is related to a Report Component!

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      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).

       

       

       

       

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

        This worked perfect and got me exactly what we needed, thank you very much! Very interesting feature to remember for future graphs as well. Happy to also bring you to new places in OneStream, we all learn something new every day! ğŸ˜Š

  • 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
      Honored Contributor
      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 in the new book but I honestly don't know.

  • MJ1705's avatar
    MJ1705
    New Contributor II
    11 months ago

    Hi JackLacava,

    In the report component I am facing a weird issue. So when I am running the intercompany out of the box report the time showed on the OneStream app is perfect but when I export this report as an excel, it shows the incorrect time. Do you know a way we could rectify this? Thanks!

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      11 months ago

      You might want to bring it up with Support, if it's the OG report this stuff should not happen. If it's customizable (I don't think so but I'm not sure), they will indicate how to do it.