Best Of
Is there a roadmap for updating to MySQL v8?
Hi,
A client has asked if we will be updating to MySQL v8 soon as we currently only support MySQL version 5.6.37?
Thanks!
Re: Daniel Galley - SharkNinja
Glad to e-meet you again Daniel! Would love to see a Domo Community Trivia contest!
Re: How to select which Metric should go on Line in a Line + Bar Graph?
Domo takes the first value and sets it as the line for this chart, so you could create a beast mode that ranks your KPI values. You could do something like this:
CASE WHEN KPI = 'Website Cart Revenue'
THEN 1
ELSE 2
END
Then you can put this beast mode in the sorting section under the filter section. This should make the Website Cart Revenue KPI the first value and show up as the line! You can also assign specific number values to the rest of your KPIs if you want them in a specific order too.
jdorsch2
Re: Value from yesterday
I think that you will need to add a field to your dataset that will provide the prior days followers. This is because the calculated fields cannot do lag functions to check the value of the previous day.
Do you think you could share a sample of your dataset? Might help someone get to a solution
Re: Unable to Display Stacked Bar Due to Partition Beast Mode
@jdorsch2 can you share what you have in your sort properties as well?
Re: Allow sorting of quick filters
I would actually like the ability to set the order. Sometimes you would prefer to not have them in either ascending or descending order. In my case, we have categories that we would like to see in a specific order and that does not align alphabetically. Would be nice to place the categories in the order I want to see them in the list.
Re: Todays Date
Yes, you can create a beast mode that simply has this:
CURRENT_DATE()
You can then use the textbox, dynamic textbox or even a table card to display the field.
Re: Dataset Email Connector
The best way to fix this would be to build a Magic ETL dataflow with this dataset as the input dataset. You can then use the Alter Columns Tile to change the data types, or you can click on the Input Dataset and click on Data Handling and choose what type you want to change it to as well as clicking on the wheel cog to handle errors. Finally, add an output dataset and then build your cards off of this output dataset.
Re: write_dataframe fails to write output of pd.pivot_table having Nulls
write_dataframe is failing here due to column names, not values. Each item in pivot_df.columns is expected to be a non-null non-empty string. Either pivot_table is returning a DataFrame with null column names, empty string column names, or non-string column names.
rco
Re: Please help me write this filter formula:
The likely reason that you are running into issues with the two tiles is that you are likely using the same column name in both tiles. This results in the 2nd tile overriding what was in the first tile. I would suggest that in the IC Exception formula tile, you label the field as IC Exceptions. In the END Exception formula tile, label that field as End Exception. Then in your Filter tile, set your filter to where IC Exception equals Include or End Exception equals Include.