Newcomer

Dashboard - Time Data on x-axis odd

Forum|Forum|4 years ago
April 8, 2022
5 replies
0 views

Hi All,

As you can see, Oct,Nov,Dec are preceding after Jan 2021. This is being repeated at many several points. I'm wondering if anyone had a similar issue.

I'm using a CV MD data adapter. Here is my CV period headers

S

Sai_Maganti

Newcomer

CV MD data adapter returns a data table without any sorting on columns. So you have to do your own sorting in the dashboard reports. Assuming you're using BI Viewer, create a new calculated field to convert your [Time] column to date time with expression ToDateTime([Time]) and use this new field on your charts.

A

Avatar-RokuAuthor

Newcomer

Hey Sai,

Here is what I'm seeing. Maybe I need to toggle some CV or DA settings?

It's a CV MD Data Adapter and I'm using the exact same expression and format is "abbreviated".

A

Avatar-RokuAuthor

Newcomer

Using the above expression - this is how the raw data is feeding in.

S

Sai_Maganti

Newcomer

Make sure the following in your data adapter

M

MarkHoughton

Contributor

Hi, the problem is the age old one when setting up months... you really need to have them as M01,M02,M03, etc it is sorting them as all the M1x's first. So because your Time dimension was set up the M1,M2,M3 way then you are stuck with it as far as I am aware.

Regards

Mark

A

Avatar-RokuAuthor

Newcomer

I know I'm stuck until our dept. reimplement the time dimension. Nothing we can do right now

Thanks for the reply back. I'm thinking to test out Koemets idea below.

K

Koemets

Newcomer

Mustafa, this particular problem is in fact really annoying. I tried to spin it in a different ways, but the best solution I came up with was the XFBR, sorting dates by their respective period value.

A

Avatar-RokuAuthor

Newcomer

Hi Koemets -

Thanks for the response.

Can you share a snippet of what the code may look like? Just to help me get started.

B

BobNelson

Newcomer

I'm assuming that based on the date of the post you have a solution by now, but I wanted to add that in setting up the adapter, we set the Add Start End Calendar Time field to True. For some reason it always defaults to False.