Hi
I am trying to do year on year comparisons of financial charges (i.e. how is each month for 2016 v each month for 2015), in essence so I end up with a clustered barchart showing months with years as the series, I have one date field in my data and cant seem to configure this as it formats it. So my source data is
Date,Charge
1/1/2015,£1200
1/2/2015,£1200
1/3/2015,£1200
1/4/2015,£1200
1/1/2016,£1100
1/2/2016,£1100
1/3/2016,£1100
1/4/2016,£1100
Hope this makes sense, thanks
Peter
Hi Peter,
Unfortunately as you said the expression editor is beta and we don't have all supported functions listed. We do not have a list in the documentation as well. If you have an iOS device you could browse the functions in the ReportPlus iOS app. But if you don't I am attaching a list of functions that we support extracted from the source code. They don't have description and arguments, but they may give you an idea of the supported formulas.
Thanks,
Diyan
Maybe I spoke too soon, as I can not find a list of the supported expressions \ methods \ functions for calculated fields anywhere and the desktop application simply lists three AVERAGE, AVERAGEIF and CONCATENATE in the expression creator (Beta). I assume it is because it is beta? Anyway if someone could list them out I am sure it would save a load more support questions (from me at least).
Thanks for the excellent support
Hi Diyan
Great thanks for that, I now have exactly what I am after.
I think the application is missing a way to simply see all the available formula, Im sure they are listed on the web site somewhere.
Thanks again for the assistance!
You could also add a calculated column for the month number using the formula "MONTH([Date])". Then you should drop the month number and month name columns in the rows pivot area. This way the data is sorted by the month number, but you could display the month name in the chart. I am attaching a zip containing an rplus file with a configured widget. Please let me know if you have any other issues or questions.
Thanks thats better but not there yet, as the sorting is now on the text so the months starts with April not January.