Date entity as String

Options
Fethi ZERARA
Fethi ZERARA Active Partner
May Badge of the Month Community Captain First Anniversary Level 200: Leveraging Board for Business Insights
in Platform

Hello everyone , i'd like to know if there is a way to add an entity in date hierarchy that accepts String , i wanna do that beacuse i'm trying to upload a table that possesses  a column which contains "YTD or TYG" so when i try to load it i get "0"  and that because i have to put a date format  -_- 

Thank you for your help !

Answers

  • Helmut Heimann
    Helmut Heimann Employee
    March Badge of the Month February Badge of the Month Community Captain April Badge of the Month
    edited March 2020
    Options

    Hi Fethi Zerara,

     

    you could add a custom time dimension to the date time-herarchy but, I don't think that will solve your problem since you would have to build up appropriate relationships for this new entity in your time-hierarchy and to which date would you want to connect "YTD" (define a relation)?

    BOARD already gives you the opportunity to calculate with YTD values using the appropriate funktion in the DataView configuration as shown here:

    image

    If you want to load already accumulated values (which I suppose, you want to do) you would have to load those values to the last day of the period (e.g. the last day of the year), probably using ETL to achieve this.

     

    Hope, this helps!

    Regards,

    Helmut

Categories