Best Of
Re: Count number of character occurrence in string
You can calculate the length of the string, remove the character you want, recalculate the length and take the difference.
LENGTH(`Color`) - LENGTH(REPLACE(`Color`, ',', '')) + 1
Re: Add collapsible sections to "new" dashboard pages like the "old" standard pages
Bumping - great idea, would greatly improve the way we navigate through dashboards.
Ritwik
Re: Add formula syntax error
@AdamC Welcome to Domo and SQL! So your statement will look like this:
case when `Column A` IN('ONEY','CMDU') then 45 else 30 end
or
case when `Column A` = 'ONEY' or `Column A` = 'CMDU' then 45 else 30 end
Your CASE WHEN is basically your IF. I'm guessing one problem you were running into is that if the data in your column is a string (basically text, though that's not always true) then you need to put single quotes around the value.
Re: If possible, how can I call a Stored Procedure or Function?
@Jose_Rojas yes, you would need to work with your AE to get the Jupyter Notebook addon. If it was me, i would be VERY explicit and adamant that you do NOT need the Data Science Package.
IMHO with the improvements in the Jupyter Data Science Notebook there is no reason to use the Scripting tiles.
But also i think you're building a couple of unnecessary hops in your pipeline.
Instead of using Domo connectors to pull data from your REST API, just do it in Python (unless it's super huge data).
instead of using writeback connector to push the data to your data lake. just use the Rest API in Python... unless you REALLY like the extra hops.
instead of running the stored Procedure in Snowflake ... yup you guessed it :D run it in Python.
Then use the dataset in Domo.
Re: Dashboard Layout - Show pixel dimensions of each item when designing
@MarkSnodgrass This is currently on our roadmap. We are exploring options to introduce new aligners on the page that could help with alignment and creating cards that are same size.
Khushboo
Re: Dashboard Layouts - Control Padding Between Cards
@MarkSnodgrass This is currently on our roadmap and we are scoping ways that could allow users to adjust spacing on dashboards.
Khushboo
Re: If possible, how can I call a Stored Procedure or Function?
@ricsanders and @Jose_Rojas Domo does not really have the concept of stored procedures or functions available for execution in Magic dataflows.
You can create stored procedures in MySql dataflows but i strongly recommend you avoid them because MySQL (v5.6) is significantly more effort to optimize and maintain if you're trying to hand dataflow pipeline design to other users.
for @ricsanders, we typically recommend building your datasets with all the users in it, then just use a Filter Card to select the user you want to display information for in your dasbhoard. -- I can appreciate that xx million might feel like a lot of wasted disk space if you have to read the entire table, but typically for Domo, millions of rows in a card is still going to yield acceptable end user experience performance-wise.
@Jose_Rojas you may need to handle your scheduling external to Domo if you have a snowflake procedure that needs to finish successfully BEFORE you ingest data into Domo. You might look at using Python to automate testing "did my snowflake procedure finish? if yes trigger Domo dataset execution."
Totally different use case, but here's an example of how you might build the LOOP structure.
Re: Combining data into one pie chart
@louiswatson You can use the Add Constants tile in ETL. You'll add one tile per branch of your ETL and name the column the same for each one (Stage), and then for each constant, put the name of the stage that corresponds to the filters.
Additionally, depending on your comfort level with CASE WHEN statements and the complexity of your filters and other tiles, you could do this without having to create different branches using a formula tile with a long case when formula.
Re: Combining data into one pie chart
@louiswatson are your stages mutually exclusive? if so, I think your next step will be a group by tile for each stage (group by stage and then count panels?) and then an append which will stack your 5 categories together.
So i'd think your end dataset goal is:
which you'd then build your pie chart off... is this what you're aiming for?
mhouston
Re: Combining data into one pie chart
They are all in a status from Pipedrive called 'Lost', I'd like to show a breakdown of the sites in lost. This is where the additional filters/date ranges differ from each dataset.
All I need to do now is group the values into the filter groups below (tenure, instructed, no tenure, tenure no planning etc) and use the values for the pie chart. I wasn't sure how to group the data and combine together, the datasets are using 'No of panels' as the value. Hopefully this helps?
