Mini Charts and Line Charts

[Anonymous]

I have created a line chart and a mini chart for trending using the same expressions.  However the trending line in the mini charts is totally different from the one in the line chart.  What could be the cause of this difference?

Regards.

Chris

[danieloberbilli]

Please upload the qvw or at least a screenshot of both objects that also shows the used dimensions/expressions

[Anonymous]

Dear Daniel

Please find herewith screen shots of requested information.  The dimension in all charts is month.  The line charts at the top should be the same with the two mini charts below for the current selections.

Regards.

Chris

[danieloberbilli]

Could it be, that you also have the cyclic group (Month, ...) in the straight table and that it just shows the results of the other dimension of the cyclic group?

[Anonymous]

Many thanks, the cyclic group is in the line chart and consists of month, quarter and year.  It is not in the straight table.

Regards.

[danieloberbilli]

the only idea I have is to check again if the dimension in the mini chart settings (see screenshot) is really the same month-field that is defined within the cyclic group. It may be that you are dealing with several month-fields and that the month field in the cyclic group is just labeled as 'Month' but contains another field.

[Anonymous]

Daniel, thank your very much for your contributions so far.  I have checked the issues raised and I do not seem to find any problem (see attached).  The group settings is using Month with a default field label.

regards.

[kuba_michalik · Accepted solution]

Months on the minichart seem to be sorted in descending order. Try playing with Month field sort order in Document Properties (as you can't customize dimension sort order in the minichart itself).

[danieloberbilli]

I think Jakub is right...if you compare the lines it seems that the sorting is going from July to January

[Anonymous]

Dear Daniel

I think i have figured out what is happening.  The line chart trend line is sorted from January through to July in the right sort order and presenting the right trend line.  The mini chart month is sorted in reverse order from July through to January from my observation when i changed the mini chart mode from line with dots to bars.  How do i sort the mini chart to give me the correct trending?

regards.