Removing filters from drill paths

wwood-accel

Hello,

 

Is there a way to remove filters from drill paths?

 

For example, if I have a stacked bar by month and by business unit and I want to add a drill path that filters ONLY by business unit and not by business unit AND month?

 

Thanks

kshah008

Hi all,

 

Can anybody help @wwood out?

Thanks!

VinceGhost

@wwood I tried to find a way in which to do this exact same issue.  I opted to instead create a second card and link it as a "related card"  

 

I left the drill down so that they have the option to see the data using that filter, but keep in mind if they use the drill they will no longer see the related card unless you decide to add it into that path as well.

 

 

kshah008

@wwood, did VinceGhost's reply help you out?

Unknown

Yes, you can remove a filter. I do this all the time. 

 

When you click a data point to drill down, you'll see the "filter" automatically applied as a blue box to the top left of the chart. If you click the x on the filter box you can remove that filter. I find this particularly useful if I want to see a larger time frame and the drill path filtered me to a single week or month.

Wolfram

This is really not good for the user experience.

 

I have an analysis of monthly cohorts, showing growth/decay over time. I want the end user to be able to drill into a cohort, to look at the growth/decay of individual cohort members. 

 

These are the filters applied when drilling down:

 

 

I only want the filter for 'minPeriod'. Yes, the end user can remove the 'Months old' filter, but they should not need to. As the developer, I should be able to specify which filters are applied.

user05535

I will be very interesting that I can create one card 2level without filter of card 1Level. It´s very useful

Is possible this option?

Wolfram

I am frankly amazed that this is not a feature yet. 

 

You offer combo charts. I use combo charts to compare things like Forecast vs. Actual. If I want to drill into a particular month, one of the two Forecast or Actual will be filtered out. This is a horrible user experience and makes me and this product look like **bleep** in front of executives.

 

 

CFO: "Why does this only show Forecast when I drill in?"

Me: "Oh its just a limitation of Domo! EVERY TIME you drill in, youll need to remove the filter "

user03544

Same problem for me.  Nobody is going to know they have to remove a filter unless they are trained, and it's annoying to have to do so every time there's a drill down.

Godiepi

In you example that is actually the whole point of drilling down to a filtered view. if your users wish to look at a specific month or any time period then they can use the date grain drop down next to the title of the card. now if what they want is to filter the card for an specific let say department, without getting rid off one of the series, then they can use the card filter or analyzer. even page filters. I am sorry but what you are describing is just a filter action on a card . not a drill down to a deeper level.  I think Domo give us all plenty of ways to accomplish what we and our users want , even more than any other platform out there.

user03544

Not true.  In my example, the top-level chart plots each department as a line.  The drill down chart plots individual staff members as a line.  Two different groupings.

 

What I want is that the user can click on the department line and then get a chart that shows them the lines of the staff within that department.

dmoney1

I agree with the main body. What Domo needs is to have the ability to expand data instead of drill (filter) the data. The thing I want to know is why there is no action towards this. It seems like there is a large enough user group here to get traction to this basic function.

 

@DaniBoy What would it take to get this actually implemented at Domo? I know the idea exchange is a possbility, but I feel like that is just a location Domo likes to send users to make them think their idea is actually considered. @Wolfram 

Wolfram

Hello, three years later!

 

I am super disappointed that this is still not a feature. After three years? I was designing a dashboard with the design dashboard feature, but it is totally unviable because I cannot control the drill path.

 

See the image. Each line represents a group of people. I want users to be able to click a line and see the trends for all the individuals. But when you click the line, you only see results for a specific month.

 

So now my users get to live with the typical dashboard experience, where they still have to deal with this terrible experience of removing a drilldown filter every **bleep** time 

ST_Superman

Rather than drilling, you could set this card up on a dashboard and have the interaction apply a filter.  This way you could place another card below this one that would provide individual user trends.  When a user clicks on a group from the top card, it would filter the second card to only the users in that group.

milleniumsalman

Hi,

I solved it a little differently. I created a new modified dataset from the original. As per the requriement in the first visualization i had to build the metrics using the last recordvalues in the dataset. But in the drill down second visualization, i wanted to build the metrics using entire time-line from the beginning of the table and not just a slice which happened to be the last record in my dataset.

 

Solution :

First Part :Was to join the original table with the subset of the table itself for the entire time period. By using ETL in DOMO, i added new columns where each column had duplicate values that i needed from the last record (as per the requirement for the first visualization).

 

Seecond Part : To solve the problem of duplicate column values in the first visualiztion, in the visualization process, i made a new calculated field which was just an average of each column value (this was done for the new columns having duplicate values). This correction gave me the values to build metrics for the first visualization card and when i drilled down to build the second visualization, i still had the original data for the entire time period.

 

To visualize further, In the spread sheet attached the original columns for the two visulaization were;

 

date

region

mean

median

lower_90

upper_90

lower_50

upper_50

 

After ETL process, here are the new duplicate columns for each row

date_new

mean_new

median_new

lower_90_new

upper_90_new

lower_50_new

upper_50_new

 

Here is the sample snapshot of State of Arkansas, where each row in orange is having the last value in the dataset (i.e. from the 3rd May for the state of Arkansas).

date	region	mean	median	lower_90	upper_90	lower_50	upper_50	mean_new	median_new	lower_90_new	upper_90_new	lower_50_new	upper_50_new
3/16/2020	AK	1.19352597	1.148167468	0.853610482	1.563361405	0.990687059	1.255346991	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/17/2020	AK	1.18543441	1.14653841	0.872546677	1.523459614	0.979034013	1.224531698	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/18/2020	AK	1.174880378	1.141086204	0.863452952	1.494848439	1.016822027	1.246834641	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/19/2020	AK	1.161129703	1.136088696	0.851267851	1.441944258	0.993082486	1.205028549	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/20/2020	AK	1.144788076	1.121379379	0.848451382	1.406053804	0.985050507	1.177709531	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/21/2020	AK	1.125066404	1.094968702	0.876886353	1.388888294	0.996349112	1.168532115	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/22/2020	AK	1.106652512	1.084864212	0.865733463	1.35135493	0.973452812	1.146165083	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/23/2020	AK	1.090375343	1.066738117	0.836364683	1.328859181	0.954564351	1.122200841	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/24/2020	AK	1.071291856	1.051787765	0.849567015	1.322867444	0.935809083	1.10466527	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/25/2020	AK	1.049204274	1.036393209	0.836115591	1.286042485	0.951833134	1.107485904	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/26/2020	AK	1.025728646	1.016994559	0.818184724	1.269440029	0.924091576	1.070190069	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/27/2020	AK	1.002872491	0.999410424	0.762520194	1.209834234	0.923307242	1.069974447	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/28/2020	AK	0.980164198	0.983885245	0.764766286	1.206177405	0.922407344	1.066030694	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/29/2020	AK	0.954166005	0.962530492	0.757144284	1.165101433	0.910699473	1.050620906	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/30/2020	AK	0.92684538	0.94016472	0.696961042	1.130087896	0.883180275	1.016003439	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
3/31/2020	AK	0.904100336	0.921624831	0.695793561	1.125594234	0.859315417	1.001493959	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/1/2020	AK	0.884200467	0.905623614	0.657950878	1.110554657	0.837922815	0.987125238	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/2/2020	AK	0.865825505	0.888135098	0.651565663	1.122893581	0.812433562	0.966179826	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/3/2020	AK	0.845448977	0.870717089	0.590042883	1.088286433	0.813718043	0.981599432	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/4/2020	AK	0.820612704	0.854432288	0.526156878	1.060339949	0.805757701	0.981285046	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/5/2020	AK	0.797753064	0.842050953	0.494379374	1.050237408	0.797723225	0.983840452	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/6/2020	AK	0.783665947	0.824465959	0.503381805	1.064449582	0.781599247	0.975193915	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/7/2020	AK	0.774090751	0.816724487	0.482805692	1.069329529	0.747956367	0.949002676	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/8/2020	AK	0.766532998	0.814098206	0.447537428	1.048055845	0.752812869	0.955242015	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/9/2020	AK	0.75262485	0.798130472	0.455508181	1.048795748	0.720646736	0.934916094	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/10/2020	AK	0.741461726	0.788778569	0.409138979	1.050000148	0.747219393	0.966463628	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/11/2020	AK	0.735104356	0.786880697	0.405943303	1.06595508	0.720644948	0.938996903	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/12/2020	AK	0.730764824	0.780929448	0.408040259	1.055980517	0.727696109	0.95975532	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/13/2020	AK	0.724792638	0.771844245	0.405281168	1.056678992	0.700415713	0.937500928	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/14/2020	AK	0.721028995	0.771683338	0.406837168	1.071530029	0.729637056	0.973527934	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/15/2020	AK	0.719078986	0.764927529	0.385303088	1.041601551	0.709957935	0.95543079	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/16/2020	AK	0.718329271	0.766347438	0.41140782	1.094313642	0.695846793	0.947219464	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/17/2020	AK	0.725440221	0.773105111	0.340595035	1.054927484	0.685028529	0.935299912	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/18/2020	AK	0.729968966	0.773864232	0.391047622	1.11934851	0.688448297	0.945877655	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/19/2020	AK	0.728065784	0.775376812	0.312595849	1.077971665	0.698466437	0.970246215	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/20/2020	AK	0.73634425	0.777734114	0.324038068	1.106583002	0.685114864	0.956526667	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/21/2020	AK	0.734241329	0.777850923	0.291802736	1.110243721	0.700362278	0.970006859	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/22/2020	AK	0.736138832	0.783839775	0.310631484	1.136610656	0.725901212	1.00983197	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/23/2020	AK	0.741097386	0.782710652	0.247377381	1.107473649	0.701663953	0.986247474	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/24/2020	AK	0.735386064	0.786631771	0.208967067	1.115301802	0.68641775	0.980183182	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/25/2020	AK	0.732480016	0.782487097	0.221285401	1.152552127	0.643163363	0.94810236	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/26/2020	AK	0.731252831	0.786416494	0.1972892	1.143855716	0.641795826	0.953263794	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/27/2020	AK	0.729677231	0.790273499	0.186817802	1.134428857	0.716482917	1.029012424	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/28/2020	AK	0.726312265	0.788850409	0.181820035	1.152772875	0.711864367	1.034802718	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/29/2020	AK	0.728435451	0.785254982	0.167487456	1.147814848	0.688929889	1.016217937	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
4/30/2020	AK	0.72600856	0.783630662	0.162864784	1.215827026	0.652430071	0.994002657	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
5/1/2020	AK	0.725792515	0.781861593	0.120914968	1.204855265	0.652745026	0.999140657	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
5/2/2020	AK	0.723063571	0.787550914	0.130829669	1.265500933	0.597171377	0.954277103	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743
5/3/2020	AK	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743	0.720312904	0.774442193	0.126869453	1.292557697	0.668709774	1.031813743

 

 

In building out the first visualization metrics, i will use the orange columns, but (remember) you will have to average or min or max the duplicate column to get the actual value you need in the first visulaization.

That way all the original columns for the entire time period will be available to you in the drill down path visualization without any filter to build the second visulaztion.

 

If there are multiple visualizations that are needed to be build, then you will have to repeat the process of creating redundant orange colored columns with duplicated values to send the original dataset columns one step down in the drill path.

 

Thanks

Salman Ahmed