Best Of
Re: Creating Page Analyzer Links
Hi @b_rad
You'd need to aggregate your data such that you have each value separated by "," (including the quotes) so that each value is properly escaped when you pass it in as a pfilter argument list.
Re: Using Magic ETL, how can i sort an aggregated string?
Hi @dmurgit1
You can't simply sort the aggregated string. You'd need to split your string into separate column then pivot those columns into rows, sort then and then reassemble them using the reverse process.
Re: Using Magic ETL, how can i sort an aggregated string?
The group by function doesn't allow you to sort your records when you're concatenating them together with a comma. You could try to use a Rank & Window tile before the group by to sort the values and calculate the row number, then attempting to do the group by on the sorted data.
Re: Can I search for column names across all datasets?
Hi @JunkDoom
Domo has a Data Governance connector which has a dataset to list all of the columns on datasets. It's called Dataset Schema. You can create a table card with that dataset and filter for any records where `Column Name` contains your search string.
Re: Is this Chart Possible
You won't be able to combine those three separate types of graphs however there is a Line + Stacked Bar chart which would allow you to get portions without the area piece.
Re: Count (Distinct) With Condition
Hi @jgospel
It's because of the extra columns you have displayed in your chart. Because you have Compliance Error, question_max_score and answer_value it's grouping by those so it's only looking at the compliance error within that specific group rather than at just the agent full name level. If you remove several of those columns that are for debugging your query will likely work.
Re: Table Card - Total to be % calculation rather than SUM, rows by week
You just need to utilize aggregates in your beast mode to add all of the elements in the group before determining the percentage.
SUM(`performed`) / SUM(`projected`)
You can then format that as a percentage to display correctly.
The problem with the Total Row column is that it adds everything together so if you're at 80% for both weeks it'll think it's 160% instead of the 80% across the total.
You could try and union / stack your data such that there is a "Total" recruiter the the aggregated data but that won't allow you to see those total records if you're filtering on a specific recruiter.
Re: How do I calculate a row total?
Also, by utilizing a window function in a beast mode it'll properly handle any filtering done to the cards instead of doing it within an ETL.
Re: Beast Mode Calc for URL Won't Activate Intranet Links
Awesome! Glad to hear it @user028768
If you could mark my answer as accepted for others to make it easier to find I'd appreciate it. Thanks!