Vertical Symbol + Grouped Bar chart Question
Hi All,
I am trying to create a vertical symbol +Grouped bar chart to show by Fiscal Month week to show the On order $ for this year and last year and the on order units for this year and last year...
Following are the beast modes that I am using
X-Axis: Fiscal month week -CONCAT(UPPER(`FISCAL_PERIOD_LABEL_SHORT`),'-WK ', `WEEK_NUMBER_IN_FISCAL_PERIOD`)
Y-Axis: UNITS ON ORDER LY ORD DATE :
CASE WHEN `FISCAL_YEAR` = `CUR_FISCAL_YEAR`-1 THEN COUNT(`units`) END
Series: -UNITS ON ORDER TY ORD DATE
CASE WHEN `FISCAL_YEAR` = `CUR_FISCAL_YEAR` THEN COUNT(`units`) END
ON ORDER $$ LY ORD DATE
CASE WHEN FISCAL_YEAR = `CUR_FISCAL_YEAR`-1 THEN SUM(`Amount`) END
ON ORDER $$ TY ORD DATE
CASE WHEN FISCAL_YEAR = `CUR_FISCAL_YEAR` THEN SUM(`amount`) END
Under the Date range dropdown and the date range field I am using the field Common Date which has the beast mode as below:
CASE WHEN `DATE_VALUE`< CURDATE() AND `DATE_VALUE`>= CURDATE() -364 THEN `date_value`
WHEN `DATE_VALUE`< CURDATE() -364 AND `date_value`>= CURDATE() -728 THEN date_value + 364
WHEN `DATE_VALUE`< CURDATE() -728 AND `date_value`>= CURDATE() -1092 THEN `DATE_VALUE` + 728
ELSE `DATE_VALUE`END
But I am getting fiscal month week getting displayed three times (please find attached the picture)..Can you please help me here..
Best Answer
Answers
-
Hi everyone, Any help on this will be appreciated!
0 -
@MichelleH : No I hadn't applied any aggregation...I tried applying the average of week number too...Still the week numbers appear thrice
0 -
@ozarkram - Could you provide a sample of data? It would be helpful to understand the structure better and to troubleshoot with schema that matches your dataset.
2 -
@MichelleH : I am using the chart under vertical bar ->Symbol + Grouped bar..I will share the sample data soon
0 -
Hi @ST_-Superman-_ Please find below the data...Also attached the excel file..
Input data
Expected output
0 -
Thank you so much @MichelleH ...This works!..Really appreciate your help!
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 86 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive