Chart Showing only Projects with Cost; how to show all projects?
Hi all,
I have a simple Table Card with only two filters, one for project number, and one for project phase. 97 projects meet this criteria. One piece of information I'm displaying in the Table Card is the planned project cost. At the moment, only 50 projects have a planned project cost. The chart is only showing these 50 projects, but I need it to show all 97. Is there a solution?
Thanks
Best Answers
-
I'm guessing that your project cost field contains nulls, which is likely eliminating those other projects. Try creating a beast mode that looks like this:
IFNULL(projectcost,0)
Drag this field into your table card and see if that fixes it. Also, make sure project cost is not in your filters.
**Check out my Domo Tips & Tricks Videos
**Make sure to
any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Yes, you can wrap IFNULL() around anything. If you are able to send a screenshot of what your card looks like in analyzer, that might help with the troubleshooting.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
That sounds like you would need to contact the software dev if it is not even showing up in your initial dataset.
Your only workaround would be to have another dataset that is either manually maintained or is another dataset that just lists all projects and then join them together in Magic ETL.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Yes. Here's a KB article on it:
https://domo-support.domo.com/s/article/360044876194?language=en_US
Here's a video I have on it:
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Correct on the compatibility. Sounds like they need to alter the original dataset for you so you don't have to create an ETL, or not have it come in as a federated dataset.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
I'm guessing that your project cost field contains nulls, which is likely eliminating those other projects. Try creating a beast mode that looks like this:
IFNULL(projectcost,0)
Drag this field into your table card and see if that fixes it. Also, make sure project cost is not in your filters.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
I agree with nulls being the issue, but I would do it in the dataflow. 😉
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks, Mark. I've used this elsewhere, but couldn't get it to work here. Thinking about it a bit more, I think it's because the PlannedCost is not just a plain attribute. It lives within a particular module of our software where the user first has to select between 1 & 9 FinancialCategoryName (Internal Resource, External Resource, Software, etc.), then they have to populate the cost for those categories. The PlannedCost is a total of all 1-9 categories that are used. It seems if there's no FinancialCategoryName set, I'm not getting the project to show, even if I use the IFNULL beast mode on the PlannedCost.
So is there a way to use an IFNULL on the FinancialCategoryName? - (which I don't want displayed on the Card)
0 -
Yes, you can wrap IFNULL() around anything. If you are able to send a screenshot of what your card looks like in analyzer, that might help with the troubleshooting.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Update: I took another look at the dataset. It seems if a project has no Financial Category set, the project does not appear in the dataset at all. Not sure if there's a workaround, or if I just need to contact the software dev, as they manage my datasets
0 -
That sounds like you would need to contact the software dev if it is not even showing up in your initial dataset.
Your only workaround would be to have another dataset that is either manually maintained or is another dataset that just lists all projects and then join them together in Magic ETL.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
I've never used or learned about Magic ETL, but it sounds like it allows you to use attributes from two different datasets? That sounds like a solution
0 -
Yes. Here's a KB article on it:
https://domo-support.domo.com/s/article/360044876194?language=en_US
Here's a video I have on it:
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Thanks - started watching & following, but ran into a problem already; one of the datasets I need is type = domo-federateddata, which seems to not be compatible with ETL. Another question for the dev? Maybe it can be converted to type = Microsoft SQL Server?
0 -
Correct on the compatibility. Sounds like they need to alter the original dataset for you so you don't have to create an ETL, or not have it come in as a federated dataset.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Okay, thanks for all your help. I have a meeting with them on Friday.
0 -
Happy to help! If you can mark any answers as accepted that helped you, that would help others in the community.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
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
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 874 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
- 146 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