Period over period chart percent change error
I created a card using the period over period chart type that shows the year over year numbers as bars and the percent change as a line. I have run across an error when the prior year number is a negative and the current year number is positive, the percent change calculated is a negative even though the change is an increase. Since this is a defualt calculation in the card I am unable to correct this. Can it be changed to make it an absolute calculation?
Best Answer

I was able to replicate that behavior as well. From what I can tell, the only way around it would be to use a line/bar chart, manually calculating your variance and build in a case statement for if your previous period is negative. If it is, this its the variance of the absolute value of the previous period compared to current + 100%, otherwise it's the standard variance calculation of (Current/Previous) 1.
Definitely seems like there should be an option that would handle those cases though on the PoP card.
Sincerely,
Valiant_Ronin**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Answers

I was able to replicate that behavior as well. From what I can tell, the only way around it would be to use a line/bar chart, manually calculating your variance and build in a case statement for if your previous period is negative. If it is, this its the variance of the absolute value of the previous period compared to current + 100%, otherwise it's the standard variance calculation of (Current/Previous) 1.
Definitely seems like there should be an option that would handle those cases though on the PoP card.
Sincerely,
Valiant_Ronin**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1 
Thanks for the suggestion. I'm also going to submit this to Domo help to see if it can be fixed for the POP card.
0
Categories
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 603 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 697 Beast Mode
 43 App Studio
 39 Variables
 658 Automate
 170 Apps
 441 APIs & Domo Developer
 42 Workflows
 5 DomoAI
 32 Predict
 12 Jupyter Workspaces
 20 R & Python Tiles
 386 Distribute
 111 Domo Everywhere
 269 Scheduled Reports
 6 Software Integrations
 113 Manage
 110 Governance & Security
 8 Domo University
 30 Product Releases
 Community Forums
 40 Getting Started
 30 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive