Search for answers here or ask a question

Comment modéliser mes données correctement

Bonjour à tous,

je dois réaliser un reporting en fonction de ce fichier excel. 

Sur des graphiques, je dois afficher le nombre de journées CP en fonction du nombre de journées. Je n'arrive pas à faire de jointure car à chaque fois de nombre de journées est doublé ou triplé en fonction du nombre de ligne. Je me suis demandée si je devais faire une table calendrier et la relier à mes deux tables mais je ne sais pas comment faire.

Est-ce que quelqu'un peut m'aider ? J'ai joins le fichier excel (données transformées) que je reçois.

Merci beaucoup.


4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Quick DeepL Translation:

    Hello everyone,

    I have to make a reporting based on this excel file. 

    On graphs, I have to display the number of CP days according to the number of days. I can't make a join because each time the number of days is doubled or tripled according to the number of lines. I wondered if I should make a calendar table and link it to my two tables but I don't know how to do it.

    Can anyone help me? I have attached the excel file (transformed data) that I received.

    Thanks a lot.


    Translated with (free version)

    • Ian MacdonaldAdmin
    • Team Lead - Product Management
    • Ian_Macdonald
    • 1 mth ago
    • Reported - view

    Hi Sonia,

    You need to use the Date Range source block in model to generate a Calendar table.

    Drag it onto your Model Flow canvas with your excel source and choose the date range you need in the properties panel on the right. Here's an example:

    Add Time Intelligence to generate all the days, weeks, months etc you might want to use in your analysis.

    In your model, join the tables using the Date field as shown. Set the join type to Bi-Directional, as you may want to analyse by attributes in each table.

    Process your model and you should be able to create the chart you need. I think this is what you want, but your description is not entirely clear.

    Hope that helps.


    Like 2
    • Aurelie
    • Aurelie.1
    • 1 mth ago
    • Reported - view

    I Ian, thanks for your help.

    I try and I tell you if it's ok. Good day.

    • Aurelie
    • Aurelie.1
    • 1 mth ago
    • Reported - view

    Hi Ian, I tried it and it seems to work ! Thank you :)

Like1 Follow
  • Status Answered
  • 1 mth agoLast active
  • 4Replies
  • 43Views
  • 4 Following