Interactive Chart not sorting

Hi all,

I am having trouble with having my Interactive Chart look as I want it to.

I have a small, sample, dataset with three columns: Kilometers, Splittime and Date.

I'm looking to create a Line Chart with the number of Kilometers, sorted ascending on the X-axis; the splittime sorted on the Y-axis and the Lines split on the seperate dates.

However, when trying to get this configuration to work, my Y-axis doesn't sort appropriately.

Please see the attached workflow for an example of the incorrect flow.

Does anyone have an idea on how to sort the column correctly?

Thanks in advance for any help!

Kind regards,

Remco

Interactive Chart Sorting issues.yxmd

Workflow

Reporting

Accepted answers

Christina_H

I similarly had a look at this and couldn't make the times sort correctly on the y-axis. However I did get it to sort correctly by converting the times into seconds:

Formula: DateTimeDiff("2020-01-01 "+[Splittime],"2020-01-01","seconds")

Interactive Chart Sorting issues.yxmd

All comments

binu_acs

@RemcoV Can you only sort the Splittime in Ascending order and try again?

Raj

This makes the split time in series but does not give any insight as the kilometer is scattered series so it is not a good practice to do so here according to my understanding we need to arrange the split time and kilometer simultaneously

RemcoV

Hi @binu_acs,

Thank you for your quick response! However, the Y-axsis seems to still not sort appropriately.

@Raj any ideas on how to split time and kilomer simultaneously? As whatever I've tried is still not working.

Raj

I have tried a lot to make the arrangement of the axis but, it was not possible for me as of now

please let me know if you get the solution for this

Christina_H

I similarly had a look at this and couldn't make the times sort correctly on the y-axis. However I did get it to sort correctly by converting the times into seconds:

Formula: DateTimeDiff("2020-01-01 "+[Splittime],"2020-01-01","seconds")

Interactive Chart Sorting issues.yxmd

RemcoV

Hi @Christina_H ,

Although it is not exactly what I had in mind, it does do the trick. Thank you!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703