Best Of
Re: If possible, how can I call a Stored Procedure or Function?
@jaeW_at_Onyx Thanks a lot for your advice, I'm in an internal race competing against Airflow. But again, if I can prove Domo can do Jupyter, it will win the race, as with Airflow we need to support the VM, the linux and Airflow setup. With Domo we don't lose that many resources doing SysAdmin tasks.
Re: If possible, how can I call a Stored Procedure or Function?
@jaeW_at_Onyx wow, thanks, those videos of creating Jupyter notebooks inside Domo seem to be the solution. We were thinking about having a separate ETL process in Airflow and from there call Domo, but that will make us have to maintain both Domo and Airflow, and we prefer, if possible, just one.
So it will be:
use domo json connector to pull dataset from third party REST API ->
use snowflake writeback connector to push extracted data to our Datalake ->
use jupyter notebook in domo to connect to Snowflake and run the stored procedure ->
use normal Snowflake connector to pull resulting table created by the stored procedure into domo
Do we need to ask for the Domo Data Science package in order to be able to create a Jupyter notebook?
Re: DOMO acting SLOW!!!!!!!!!!!!!!!!!!
I wish we would have just stuck with Power BI.... and maybe I need to go back to that tool.
Bar Diverging Chart Tutorial
Diverging bar charts are a simple standard bar chart that can handle both negative and positive magnitude values.
How to build in Analyzer:
- Select ‘Horizontal Bar’ under ‘Popular Charts’ as the Chart Type
- Drag ‘Profit’ from the Data pane into X-Axis
- Drag 'Product' from the Data pane into Y-Axis
- In Chart Properties, configure the following:
- General -> Sort on Totals: Descending
- Gridlines -> Hide Gridlines checked
- Gridlines -> 'Remove Min/Max/Avg Lines' checked
- Data Label Settings -> Text as '%_VALUE'
- Data Label Settings -> ‘Use Scale Format’ checked
- Data Label Settings -> ‘Use Scale Abbreviation’ checked
- Value Scale (X) -> Show Label as 'Never'
- Hover Text Settings -> Hover Text as '%_CATEGORY_NAME: %_VALUE profit'
- In Color Rules, configure positive values to be equal to or above 1 to be yellow.
Screenshot:
Pris