04-08-2022 03:02 PM - last edited on 05-24-2023 12:04 PM by JackLacava
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
04-09-2022 07:45 AM
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.
04-10-2022 10:52 PM
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".
04-10-2022 11:14 PM
Using the above expression - this is how the raw data is feeding in.
04-11-2022 03:19 AM
Make sure the following in your data adapter
04-11-2022 09:30 AM
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
04-11-2022 11:53 AM
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.
04-11-2022 11:12 AM
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.
04-11-2022 11:50 AM
Hi Koemets -
Thanks for the response.
Can you share a snippet of what the code may look like? Just to help me get started.
Wednesday
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.
Inside BiViewer, we then ignore the time dimension and replace it with the EndDate field.
Thursday
Thanks for the guidance on this @BobNelson