Reverse Date Order

[stei0792]

Dear Team,

I am in need of some code modification so that my Date column is in reverse order, so most recent dates to past dates. Below is what I tried, however this just shows the two dates first not necessarily this as a range from 2019-01-31 to 2010-01-31. Any solution would really help if you have any time to help.

df is the dataframe

rpivotTable(df, rows=c("ForecastGroup","Date"),
cols=c("Region"), aggregatorName="Sum",
rendererName = "Table", vals="Tons",
sorters=
"function(attr) {
var sortAs = $.pivotUtilities.sortAs;
if (attr == "Date")
{ return sortAs(["2019-01-31", "2010-01-31"]); }
}"
)

Thanks,

[jangorecki]

If you turn them into factors you can get any custom order you want by defining order of factor levels. Once #106 merged.