Target line

@Patricia_Zavisky - here is how you would need to set this up to achieve 2 distinct lines.

You would need to define a series for each FY goal. You could do this in either your base dataset, an ETL, or in a Beast Mode. Example below.

Example output.

Alternatively, you could make use of a bullet chart to avoid having to map the FY series.

With both of these options you can adjust the date grain to show by month, quarter, year, etc. If you choose to show by year, make sure you have your FY settings enabled with Domo to choose the "Fiscal Year" option.

So my recommendation would be to use the built in Fiscal Year feature offered by Domo. You can set this up by emailing your CSM and Domo Support. See the below linked support article that details the information you will need to supply.

Alternatively, you could also use a date dimension dataset joined up to your base dataset in an ETL. This date dimension dataset would define the FY months.

If you set up the FY feature, you can use the built in date grain functionality offered by Domo.

If you are set on using a beast mode, you could accomplish it using something like this. Remember to either set your aggregation of FY goal as an average, or split the total into monthly amounts if you are evaluating by month and want to sum.

CASE

  when MONTH(date) in (4,5,6,7,8,9,10,11,12) then CONCAT('FY ',YEAR(date))

  when MONTH(date) in (1,2,3) then CONCAT('FY ',YEAR(date)-1)

end