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
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive