Best Of
Re: Remove answered questions from the list of unanswered questions
@RobSomers - There's no intuitive button appearing for accept an answer. You have answered my question and I see links for Flag, Quote, Insightful, Agree, Like, Awesome, and LOL. Where is the accept answer link?
Re: View as user or view as role
This is a great idea! This would be helpful for validating PDP policies
Re: How can I group these results by date?
@Zel Is your date column just dates or is it datetime? If it's datetime it could look like the same date but they're actually unique because they have different times in the background. If it is a datetime column, try using a DATE() function on it and see if that works.
Re: How to exclude a card from getting filtered? (slicer filter)
Hi @Zel, you can change the way the ‘Month Slider’ card interacts with the rest of the cards on your dashboard. When you edit dashboard and then click ‘Edit Content’ of that slider card, you'll get the following:
Throught ‘Apply to selected Cards’, you can keep Card #2 as normal interaction and exclude Card #3 from slider filters.
Let me know if there are any questions, or you are looking for something else.
amehdad
Re: How to count strings in a column containing a comma delimited list of strings in each row
The way I did it in SQL, it doesn't matter how many commas there are. In ETL, I'd have to create something recusive to make sure you can get any number of elements typed into a string. If you know you won't exceed the number of delimited items you show, something like this will work.
Using that flow, I then went out and had some website give me random city names which I typed into my webform.
Re: Sort by Top 20
@chrissy Of course! Have you named the output dataset? In your earlier screenshot it looked like you had not named it yet, which would prevent it from running
Re: Sort by Top 20
@chrissy There are two steps involved in the Rank & Window tile: selecting the partitions/order and then applying functions. So far it looks like you've only competed the first step. Here is an article on how the tile works:
In the Rank & Window tile you will want to order the functions on Total Activity (2) descending (3) and partition by insurance_name (3). Then click "Apply" in the top right corner and then create a new field using the Row Number function. This is the field that you will use to filter your card to the top 20.
Re: Sort by Top 20
@chrissy You will need to use a formula in the Group By tile instead of the Formula tile to use a COUNT(DISTINCT ) since that requires aggregating the data.
Re: Sort by Top 20
@chrissy If Total Activity is a beast mode, then you will need to recreate the calculation in ETL using a Forumla or Group by tile, dependng on whether it includes aggregation
Re: Sort by Top 20
@chrissy Depending on the chart type you're using, that should work as long as you also have your data sorted. Can you please share a screenshot of the analyzer (hiding any sensitive information) so we can help troubleshoot?