Best Of
Re: Is there a way to auto-delete the data after a certain period of time?
Hi @yli_2596, I am assuming you are referring to the data in the underlying architecture, and for that, there's currently not an easy way to delete data. A few options you can explore are:
- Creating a dataflow to input your dataset, filter out the rows you don't want and then write it out to another dataset,
- Temporarily using the replace method and then go back to your append method (using the ETL tiles),
- Requesting certain rows to be deleted via Domo Support
amehdad
Re: Adding a cumulative total line in a multi line chart in Domo
Hi @snguyen, here is a write-up outlining how to get calculated fields for running total: https://dojo.domo.com/discussion/comment/56863#Comment_56863. It is also worth noting that in a Bar + Line graph option, one can specify the number of lines and bars you want to display as running totals (through Chart properties under General).
amehdad
Re: Participate in a 15 minute survey and receive a complimentary report ($895 Value)!
DONE
amehdad
Re: How to ensure data for each month gets displayed in one row in this table chart instead of2rows
Hi @Abhijith, before the beast mode, in your ETL, add in a 'Group By' tile to group SUM(`Total Charge`) by MonthYear.
amehdad
Re: Microsoft D365 Finance and Operations Connection
Hi @jackson_obara, I assume that this is the connector for D365: https://www.domo.com/appstore/connector/microsoft-dynamics-crm-connector/overview. Was there anything in particular you were having issues with?
amehdad
Re: Slider Cards not showing all data/options
Hi @D-Rab, the warning message indicates that all of the data is present, but on the card level, the visualization has been truncated. What you should do is reduce the amount of data coming into the dataset you use, or perhaps adding a Search bar on the slider card would enable the other people to come up.
amehdad
Re: Adding multiple series in Grouped and Stacked Chart
Hi @Pedro_Valverde,
There's a graph, the 'Line + Grouped Bar' chart type [https://domohelp.domo.com/hc/en-us/articles/360043429153-Grouped-Bar-with-Line-Chart], that by default gives multiple bars and a single line for your defined measures. You'll have Series blocks available as you add in your measure.
Also, if you want multiple lines instead, you can go the General section under Chart Properties and set the 'Series on Left Scale' option to however many lines you want.
Let me know if you are after something else.
amehdad
Re: Connecting Woo Commerc
Hi @KenTravels, this is a good first place to start to understand the steps of setting up: https://domohelp.domo.com/hc/en-us/articles/1500000161782-WooCommerce-Connector.
Did you have a particular question or issue around connecting?
amehdad
Re: Value Average returning incorrect average when filtering?
Nice! Yeah typically nulls are ignored when calculating averages but I guess with your usecase with the Rank and Window function etc, Domo didn't know how to handle the blank values.
amehdad
Re: Value Average returning incorrect average when filtering?
Hi @ibtisamyyy, could you please share your calculations for that 'Percentile Ranking'?
amehdad