I am trying to create a GI to show this years sales data compared to LY sales. Any ideas how to get started with this? I have pulled the data since @yearstart and for where docdate >= @yearstart-1 and docdate<= @yearstart-1. How can I show those on the same line graph?
Best answer by aaghaei
Whatever you want to show on axises will need to be in one column. So in your case you will need 2 columns in your result grid (of course you can have more columns but for sake of DB I mean). One column is going to be Year and another one Amount or Quantity. The qry or amt is straight forward. For the year column you will need to use a formula that extracts the fiscal year based on a fixed value comparison or a cutoff month parameter. Possibly the easiest way is to get the left 4 digit of TranPeriod or FinPeriod. Something like =Left(DAC.TranPeriodID, 4) or get year from DocDate something like =Year(DAC.DocDate)
In DB then you will use this formulated column let say you call it Year, as axis and Amount as value and you can have a comparison column chart
+10Whatever you want to show on axises will need to be in one column. So in your case you will need 2 columns in your result grid (of course you can have more columns but for sake of DB I mean). One column is going to be Year and another one Amount or Quantity. The qry or amt is straight forward. For the year column you will need to use a formula that extracts the fiscal year based on a fixed value comparison or a cutoff month parameter. Possibly the easiest way is to get the left 4 digit of TranPeriod or FinPeriod. Something like =Left(DAC.TranPeriodID, 4) or get year from DocDate something like =Year(DAC.DocDate)
In DB then you will use this formulated column let say you call it Year, as axis and Amount as value and you can have a comparison column chart
+4
Resulting Dashboards
+10
See this thread. You need to duplicate your rows to represent each period or category. The easiest way to do that is through an attribute. Dashboard: Sales to date vs last year | Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
