Forum Discussion
Date not sorting properly on line graph
Finally, you explained the full issue. Yes, it is a known issue (or how it works) if you are using field parameters, it doesn't retain the sort order. I would recommend using calculation groups to switch between measures (you will get the same result as FP) but it will retain the sort order. That is what you need to do.
Super UserWhat do you mean by doesn't stay that way? When it is changing automatically?
It's a report of sales/booking data and I have it hooked up to a parameter so that they can switch between viewing Sales dollars, sales units, average deal size, amd attach rate. So say I'm viewing sales units in a quarterly timeline, I set the line graph to sort ascending, I then toggle to view the dollars in the parameter, if I then switch back to units, my sorts don't hold and I have to reapply the sort by ascending.
My ask from my executives is to have that sort be default so there's no need to do that every time you switch parameters. In other words, there is not a scenario where anyone would want to see the data not in chronological timeline order.