Hi all, I am trying to build an expression (see below) of aggregated values, now it's obvious i am doing something wrong because is not giving me a correct result, appreciate if someone can point me in the right direction. {Sum(ObjectDetails_data.Net_Billed)-Sum(ObjectDetails_data.Costs)} / {Sum(Obj...

Hi Lech,

Many thanks for your reply, I have found a solution, for the days i formatted them in the sql query using dateparts function, and there is no need now to place them at an angle.

Warm Regards,
Daniel

bump

Hi all, I have a couple of issues on a line chart that i have built, one of them is how to show the days on the x axis, the problem is that the date is showing as a time stamp which is long and makes the dates show all jumbled, how can i fix this? The other issue is how to show the dates diagonally,...

found solution, it was a query problem.

Hi all,

How do i make the bar chart to show all the months, at the moment is only showing a few and leaving some blank.

Warm Regards,
Daniel

that's perfect it worked, thanks Lech.

Warm Regards,
Daniel

I am not sure where exactly, there is no dropdown to choose, how would i go about it to write it?

Best Regards,
Daniel

bump

Hi all,

Does anyone know how to format numbers in a bart chart in thousands, millions i can't find that option.

Best Regards,
Daniel