Completing date column or Axis

Options
ytekaji
ytekaji Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 4 Partner

Hello all,

I have table with three columns:

Username, Month/Year , count of access

some of users accessed in two months only, so they will have two entries only in this table.

Now, when plotting this table on line chart, those users will have two records only in the chart, is there a way to lock the date axis to show all months/year regardless of the actual number of months containing records?

I mean, I want to see all months in the date axis, and then for any month which does not have access count, it will just put 0.

Thanks

Yamen


Operating system used: RHEL

Tagged:

Answers

  • Miguel Angel
    Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
    Options

    Hi,

    If you click on the downward arrow next to the axis letter, you can access the axis options.

    Here you can specify a manual range between your desired values.

    Capture.PNG

  • AshleyW
    AshleyW Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 161 Dataiker
    Options

    Hi @ytekaji
    ,

    Is your Month/Year column parsed as a date? If this column is parsed as a date, then the periods containing no data will show up as empty bins on the x-axis of your chart.

    For example, in the screenshots below I've removed all data from May 2022 in my dataset to purposefully create a missing chunk like what you describe in your post. My date column is parsed as a date, and my chart has no bars for the May period since there is no corresponding data in the dataset anymore.

    Screenshot 2022-10-21 at 10.41.00.png

    LMK if this helps!

    Cheers,

    Ashley

Setup Info
    Tags
      Help me…