topic Re: Sorting by Week in bar chart in App Development

Sorting by Week in bar chart

pittouti — Thu, 14 Jan 2021 10:45:18 GMT

Hello everybody,

I will need your help please

I have a graph and the x-axis is expressed in Year / Week

the problem is that I can't seem to sort through these weeks

I tried all the possible sorting options, but no result

Prashant_N — Thu, 14 Jan 2021 12:05:56 GMT

Hi,

In sorting tab of chart you can enable custom sort and pass your week field.

Might help you

Regards,

Prashant

pittouti — Thu, 14 Jan 2021 12:32:00 GMT

when I put the x-axis only the sorting is correct but as soon as I put the formula of the y-axis the sort is wrong

Prashant_N — Thu, 14 Jan 2021 12:41:47 GMT

Hi, Are you using calculated dimension on Y axis? or normal dimension.

pittouti — Thu, 14 Jan 2021 12:52:59 GMT

Calculated dimension

Sum (xxxx)

pittouti — Thu, 14 Jan 2021 13:00:48 GMT

I found the solution

you had to use combo chart and not Bar chart

Thank you