Comments
-
@JonavilCello , If you are familiar with DOMO API using python or Java, you can create a table dataset with mapping to dashboard and users. Here is the link for the reference. https://github.com/domoinc/domo-python-sdk
-
Yes, I have done using python. This is a link to the documentation and it has some great examples on how to use api. https://github.com/domoinc
-
@user09167, I dont think limit is supported in the beast mode. The other option is to sort the total revenue by descending order and set the data table row to 10. This will only give you top 10 companies by revenue. Let me know if this worked!
-
Hey @user08100 @tylerdenton @user03383, This error is pretty common for the pushing data through workbench. There are multiple things that might cause these error: 1 - The folder or drive where your files resides. If your folder or drive is permissioned based then this is something I have dealt many times. 2 - If the…
-
Hey @Rob_E, Sometime this happens if the filter you are trying to use is a column that is some sort of calculation or formula created in the beast mode. Do you have like a screenshot that you can share?
-
Great. Glad to Help!
-
I dont think there is an option in the pivot card to display zero if the value is null. If your Product name does not change that much, you should be able to replicate the sumo card using table card. Use the [Created At] in the first column of the card and for the rest use a beast mode to do calculation for the product.…
-
Hey @user09729, Are you doing any calculation [especially division] in beast mode for the visualization. If that the case, it might be caused by the zero issue. This can be avoided by using nullif statement in numerator. For ex: SUM(CASE WHEN X = 'X' THEN `Duration of Call` END ) / NULLIF(COUNT(CASE WHEN X = 'X' THEN `Date…
-
You have to use the beast mode and thats the only way to accomplish this. Try creating beast mode for this columns: Distinct orders ? COUNT(DISTINCT(ORDERS)) Avg order size:> SUM(ORDERS TOTAL)/NULLIF(COUNT(DISTINCT(ORDERS)),0) let me know if this works!
-
There should be atleast some common columns on all the datasources to achieve the page lever filter. The one way to do is to add one more column to all the datasource. This can be done by naming "School" as column name on all the datasources that attributes to the name of school . You click on analyzer and set school as…