Chart Sorting Bug

Hello Jasper,

Thanks for contacting the yellowfin support team,

I just understand is this happening for all the bar charts or any particular one?

Have you tried this with different data ?

Regards,

Chaithanya V M.

Hi Vemu,

I did some test and it looks like it's only happening on reports coming from a specific view. The report also has a sub-query using the same view.

The sorting problem doesn't seem to be happening on all report created using that view, some reports are actually working fine.

I've tried creating the same report set up using a different view and it works properly.

Thanks,

Jasper

Hi Jasper,

Thanks for your analysis,

I would like to understand how you are creating the View (Using freehand Sql/ Manually)

We would like to recommend to create a new View with the same data and try to replicate the same.

Regards,

Chaithanya V M.

Hi Vemu,

The view was created by joining 2 drag and drop tables, no manual SQL codes aside from calculated fields.

I've recreated the view and the report, but currently waiting for the client's data refresh as the report doesn't have values for the field needed for it to display the stacks. I'll update you again soon.

Thanks,

Jasper

Hi Vemu,

Sending you the export file, in case you want to replicate the issue on your end.

Thanks,
Jasper

Hi Jasper,

Good Day!

Since we don't have the data source from a client, we are unable to replicate this with yfx file.

As you are trying to replicate this just wanted to check how it goes.

Can you please suggest the user create the same view once again with the same data and try to replicate the same.

Please let me know how it goes.

Regards,

Chaithanya V M.

Hi Vemu,

The export file I uploaded actually contains my recreated view and report. I got the same sorting problem.

Thanks,

Jasper

Hello Jasper, Good day!

I'm trying to Import the yfx file which you have provided but I'm unable to import it, Because of the data. Can you please try to replicate the same with the SKI team data source and provide the YFX file to us.

Regards,

Chaithanya V M.

Hi Vemu,

As requested, attached is the export file of a test report with the same sorting problem. I created the report using Ski Team data.

Thanks,
Jasper

Hi Jasper,

Thanks for sharing the required details, I'll replicate this in my local environment & I will update you on my findings once my Analysis is done.

Regards,

Chaithanya V M.

Hi Jasper,

I'm trying to import the below yfx file but unfortunately, the report not importing only the view getting imported, Can you please help me with the video that how you are creating a report/chart so that I can create a report/chart and replicate same?

Regards,

Chaithanya V M.

Hi Vemu,

I currently don't have a way to record my screen so I just captured screenshots of how the report looks. Attached in a zip file.
Also included is a PDF export of the report, the tabular report has the dates properly sorted, but the chart doesn't follow.

Hope this helps.

Thanks,
Jasper

Hello Jasper,

I hope you are doing well.

I have replicated the same in my environment however I got the same results & I'm attaching the replication video here, Could you please check and confirm if I missed anything?

Video Link: https://watch.screencastify.com/v/DyE0Apr4QFQmrGEx2khy

Regards,

Chaithanya V M.

Hi Vemu,

Yes, that's the exact results we are seeing.

Thanks,
Jasper

Hello Jasper,

Thanks for the confirmation, This seems like a Bug as I have replicated the same & I'm also facing the same results.

I will go ahead and create a defect logged with the Dev team, I will update you once I hear back anything from them.

Please feel free to respond here if you have any additional questions.

Regards,

Chaithanya V M.