Charting Monthly Sales in Designer RRS feed

  • Question

  • I have transactional data with sales dates and sales amounts that I want to plot in a line chart with sum of sales for each month.

    This seems surprisingly difficult to get charted and sorted in the right order in an intuitive way.  

    I've tried variations of month/year formats and the time sorting order in the chart is always wrong.

    What is the best practice to do this presently in BI Designer?

    Thursday, July 16, 2015 9:42 PM