Best Of
Re: Turnover calculation query
Hi @Abhijith, so you need two calculated fields for 'Exit' and 'Employed/Headcount'. Using the fields from the ETL, the Exit beast mode would like:
''' SUM(SUM('Terminated')) OVER (PARTITION BY YEAR('Last Day of Month'), MONTH('Last Day of Month') ORDER BY 'Last Day of Month')
You would then need to calculate the rolling average headcount for each month (year vs prior year), which I don't know how to code dynamically.
After getting those two working, you would combine to create the annual turnover rate calculation.
amehdad
Re: SharePoint Writeback Connector
Hi @yli_2596, it may be that the SharePoint site you've used (using the Site and Group Site ID) only has the one place recognisable by the connector to store data (i.e. The external sharing settings, permissions for your other featured sites are not the same as your root/base level site).
amehdad
Re: Formatting Numeric Values within CONCAT functions to Currency
Excellent! Thank you for sharing @MarkSnodgrass and thank you for writing up the exchange articles @GrantSmith. Have a great rest of the day y'all
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: 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: Import multiple files into single Dataset
I just learned of a simple solution that works only if the source files are in CSV format.
If you create a new DataSet Job for Type CSV, you can specify the source as a folder rather than a file. Then as long as all of the files within the folder are CSVs, and all have the same fields, then they are all imported as if they were a single file, and there's no need to specify any file names.
nitot
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: 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