Best Of
Re: Highlight pie chart slice by filtered selection
Manasi mentions a possible beast mode calculation. You can create a calculated field that will categorize suppliers into selected supplier and all others.
CASE
WHEN Supplier = Selected_Supplier THEN 'Selected Supplier'
ELSE 'All others'
END
Or us WHEN Supplier in (A, B, C, etc).
Re: Can DOMO R or Python help on my request? but I'm not able to find R/Python function...
You do not have to have access to the Python tile to use Python with Domo. In my opinion it is a useful skill to learn. You can install Python on your computer and then create code that works by executing it with a batch file. Or use Visual Code (an interface) to access Python.
If you do use Python outside of Domo, to interact with Domo, you should make sure its running from a server that is stationary. Not on a person computer or laptop that moves about.
Re: Can DOMO R or Python help on my request? but I'm not able to find R/Python function...
A Python script is a text file containing Python code, with the extension ".py". If you are not familiar with Python as a language, you can use AI to help you. Obviously, running it from within a Domo tile is most useful for Domo integration.
Running a Python script from a batch file looks like this -
Running Python from Visual Code looks like this:
Re: Rating Card
I did try a waffle but could not figure out how to get it to reduce the waffle size to one row.
Ashleigh
Re: Rating Card
To generalize @MarkSnodgrass 's solution a bit, you can use most Unicode characters to hack different visuals like this into your tables, summary numbers, chart labels. There a lot of lists of available Unicode characters, but this is my go-to:
Re: Rating Card
You can make stars by doing a beast mode like this:
(CASE
WHEN AVG(Object_Health_Score) >= '.8' THEN ' ★★★★★'
WHEN AVG(Object_Health_Score) >='.6' THEN ' ★★★★☆'
WHEN AVG(Object_Health_Score) >= '.4' THEN ' ★★★☆☆'
WHEN AVG(Object_Health_Score) >= '.2' THEN ' ★★☆☆☆'
WHEN AVG(Object_Health_Score) < '.2' THEN ' ★☆☆☆☆'
END)
They end up looking this :
Use the Heatmap table:
Re: Flex table
@Elnaz Good catch! Yes, that setting will change the color direction for all fields. Unfortunately the Flex Table chart is not super flexible. Here is an Ideas Exchange post I'd recommend commenting and upvoting for enhancements to it:
In the meantime, you may be better off using the Table/Mega Table chart type in this instance since you can use the color rules as @ArborRose suggested. If you want to add graphics within the table, here is an article on how you can do that:
Re: Can DOMO R or Python help on my request? but I'm not able to find R/Python function...
I think we need more information about the tables and joins. But it certainly seems like it would be no problem to handle in Python. I have various daily tasks that I perform using Python. My ETLs produce the dataset I need and I use Task Manager and Python to extract them as Excel files to direct paths on our network.
Re: Can DOMO R or Python help on my request? but I'm not able to find R/Python function...
@Lu_zhang ETL has Scripting Tiles that you could use to code R and Python within Domo, though your access depends on your instance's subscription.
Here is an article about these tiles:
Re: Can DOMO R or Python help on my request? but I'm not able to find R/Python function...
Hi @Lu_zhang ,
If you are inquiring about the location of the Python/R tiles within ETL, it appears that based on the screenshot you provided, you do not have access to them. They should be located under the Scripting section.
