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
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.
Thanks for the guidance on this BobNelson
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.
Hi Koemets -
Thanks for the response.
Can you share a snippet of what the code may look like? Just to help me get started.
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
Using the above expression - this is how the raw data is feeding in.
Make sure the following in your data adapter
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.
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".
