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.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman2 -
@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
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive