Target line
Hi I would like to show a target line for fy 24 (April 2023 to March 2024) and then start a new line starting for fy 25 (April 2024 then onwards)
Can I use one target line which moves from target - 20 up until March 2024 the target 11 - from April 2024 onwards.
Best Answers
-
@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.
David Cunningham
** Was this post helpful? Click Agree π, Like ποΈ, or Awesome β€οΈ below **
** Did this solve your problem? Accept it as a solution! βοΈ**1 -
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)
endDavid Cunningham
** Was this post helpful? Click Agree π, Like ποΈ, or Awesome β€οΈ below **
** Did this solve your problem? Accept it as a solution! βοΈ**1
Answers
-
@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.
David Cunningham
** Was this post helpful? Click Agree π, Like ποΈ, or Awesome β€οΈ below **
** Did this solve your problem? Accept it as a solution! βοΈ**1 -
Hi Thanks. If I wanted to create in Beast mode what that formula look like?
0 -
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)
endDavid Cunningham
** Was this post helpful? Click Agree π, Like ποΈ, or Awesome β€οΈ below **
** Did this solve your problem? Accept it as a solution! βοΈ**1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 298 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 680 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive