Trend NOT showing with Date as X axis

Mahulima
Mahulima Contributor
edited February 7 in General

I am getting trend when using a different column in X axis than Date

image.png

But when I am using Date the trend is not coming its BLANK.

image.png

I have date as the Batchtime metadata, and I am trying to use the trend on below data

image.png

I have done trend many time earlier where I had seen trend was coming good even if I have the date in x axis but that time date format was UTC format. Is that the reason it is not working in this case as the date is not in UTC format?

Comments

  • Josh Boxer
    Josh Boxer Administrator

    As you say,  'the date is not in UTC format'. Use a transform step to convert the column.

  • Mahulima
    Mahulima Contributor

    @Josh Boxer is it so it only supports UTC date format? any experian documentation is there on that? Also any reference on converting the date to UTC date? I just tried to add z in the end but that way also its not working. for now just wanted to make this working even if I understand UTC date is 2 hrs behind than the time in my server timezone

  • Josh Boxer
    Josh Boxer Administrator

    Try selecting the other column 'Load date' and see it that works to give you some additional info on what you are aiming for. With the column you want to use, do you even need the time, if not you could strip everything after the date? If you do need the time then remove the milliseconds should be enough.

  • Mahulima
    Mahulima Contributor

    @Josh Boxer I tried with Load date and that is also not working as its showing there are Duplicated in Load date so its not supporting that. I need the time so I will tried without millisecond, data looks like this

    image.png

    trend with Group name

    image.png

    Trend with batch timestamp or new date

    image.png
  • Josh Boxer
    Josh Boxer Administrator

    I am not able to replicate what you are seeing. However I update the column values, the Chart is able to be plotted as expected:

    image.png
    image.png

    Suggest some trial and error using the Date functions until it works:

    image.png

    or hopefully someone else has seen similar and can help

  • Mahulima
    Mahulima Contributor
    edited February 11

    @Josh Boxer this is also not working when I have timestamp. but working when I just have date

    is it so that I need to make it in this format?

  • Josh Boxer
    Josh Boxer Administrator

    If you want to send me these 5 rows I will take a look later this week.

  • Mahulima
    Mahulima Contributor

    2025-01-30 14:57:42.113Z[UTC]

    30/01/2025

    1118.205

    2025-01-31 13:13:00.594Z[UTC]

    31/01/2025

    1464.585

    2025-01-30 14:53:17.028Z[UTC]

    30/01/2025

    1221

    2025-01-30 14:40:41.471Z[UTC]

    30/01/2025

    1110.675

    2025-01-30 14:33:57.524Z[UTC]

    30/01/2025

    1110.675

    2025-01-30 14:37:41.116Z[UTC]

    30/01/2025

    1110.675

    2025-01-30 14:27:43.640Z[UTC]

    30/01/2025

    1208.025

  • Josh Boxer
    Josh Boxer Administrator

    Hi Mahulima

    I loaded these rows as alphanumeric values, but was still unable to replicate what you are seeing with your charts. Column1:

    1.png

    (i cannot see why it would change the behaviour, but place a Sample/limit the number of rows to 20 before the chart to see if that makes a difference).

    Yes you could try formatting the column values to see if that makes a difference to you

    3.png

Categories