Why Vizioneer?

My photo
Atlanta, Georgia, United States
The "Vizioneer" comes from mashing two words that have shaped my world for most of my adult life - Engineer and [data] Visualizations (or Vizes to those who know what's up). Graduating from first from Oglethorpe University in Atlanta, followed by Georgia Tech with my Bachelors and Masters in Civil Engineering, all of which taught me to think through anything and everything - problem solving, "engineering" solutions, teaching to the "ah ha" moments - is what I love to do. In 2010 that investigative, engineering mindset intersected a job change and a plunge into the world of Data Analysis. In the search for the next great thing I stumbled on to a data visualization and dashboarding product called Tableau software and things just took off. So now I guess you could call me that engineer with the sweet data visualizations - or just "The Vizioneer" :)

In 2013, I joined the incredible team at Slalom, focusing on Tableau and it's been an amazing experience. Recently in 2014, I was honored and humbled to receive Tableau's highest recognition of being named a Tableau Zen Master. Follow along to see what happens next :)

Tuesday, June 16, 2015

Clickable Drillable Cascading Dynamic Parameters in Tableau

Clickable, Drillable Cascading Dynamic Parameters in Tableau



Dynamic parameters are a well-documented demand in the Tableau community. The reasons for this are numerous but most of all simply goes back to better enabling advanced analysis with a better, more intuitive experience for end users. My experience is no different.  It’s not a problem that I run into often, but when I run into it, it is a seemingly endless brick wall between the analysis that I can do and the analysis that I want to do.

Now the solution that follows solves a fairly specific problem (which we’ll talk about) and is not intended to be an end-all be-all solve for dynamic parameters (we still need Tableau on that one).  But what I am going to show you is extremely powerful in the right circumstance - and the funny thing is that it’s been right in front of our faces all this time. 

The solution comes from an actual client problem that was a bit of a brainteaser for a few hours. Before I go any further, a big thanks to both Chris Toomey and Allan Walker of Slalom for allowing me to bounce some ideas off of them, even though I went in a different direction with this solution. 

Here’s the situation that were solving for in the analysis that we want to create:

Working with a large organization with a five or six step hierarchy, some steps have many hundreds of members, and the hierarchy cascades very well (ie walking down a step drastically reduces the pertinent data).  The analysis I want to show is a year-over-year percent change metric (or maybe a few metrics – sales, profit, cost, etc…), where you can see both the parent and its relevant children over time AND where the user can either select a child to drill into (making it a new parent and displaying its children, one level down in the hierarchy) or clicking and giving the ability to walk one step back up the hierarchy. Oh, and the client JUST upgraded to Tableau Server 8.2 (gasp) - so a level of detail calculation is out of scope on this one.

Did I lose you?  They say a picture is worth 1000 words, so in terms of superstore data here’s an idea what I’m talking about:



As you can see on the left we’re showing year-over-year change in sales by two different levels of detail: the thick gray line represents all of superstore, while the three thinner trend lines represent each of the different departments that make up superstore (Technology, Furniture, and Office Supplies). Here’s why this is visually so important - the parent is giving context to the children, so if you can understand that a parent is down 10% year-over-year, you’ll actually have admiration for a child that was only off 5% over the same period of time. Similarly a child that is up 20% year-over-year doesn’t look quite so good when you realize the parent was up 40% year-over-year.  Seeing both levels of detail is extraordinarily powerful visual analytics especially in very hierarchical organizations.

Now creating these views in Tableau at each level of the hierarchy is not especially difficult - what is extraordinarily difficult is creating the interactive flow and filtering between these different levels of detail in an intuitive and excellent user experience.  So the challenge became how can we dive in and out of a piece of the hierarchy without robbing users of a great experience? I’m glad you asked…

Let’s get a couple questions out of the way. 

Is publishing to Tableau Server or Tableau Public required for this solution?
Yes, actually it is.  If your organization doesn’t have Tableau Server and you can’t publish your data to Tableau Public, this isn’t going to work for you.  This hack takes advantage of a trick with URL parameters, which means it will only work after the workbook has been published.  We’ll talk about this more in a bit.

Did you say something about dynamic parameters?
I did and here’s why - we need to use parameters because we need to know what level of the hierarchy we need to be on (are we drilling in or going back out?).  We also need to use parameters because we need to hold each of the values that we’ve drilled into the hierarchy (we’re basically creating a breadcrumb).  The easiest way to understand what I’m talking about is by drilling into the viz below.  The simple viz shows how you can leverage logic based off of parameters to select the correct sheet/level of the hierarchy as you drill in.



Note: I’m going to show two different solutions to solve the same problem.  This first solution (above) is the lesser of the two as it has the most ‘gotchas’ and by far the worst user experience - parameters don’t cascade (or ’show relevant values’ as quick filters can) so by the time you make your second selection only 1/3 of your choices will actually produce another visualization. Imagine if each step had dozens of options, they would be beyond frustrating to get three levels into your hierarchy. Also from a user experience, if I want to drill into something that interests me I want to do it by clicking on or hovering over that piece of data.  Having to select where to drill via a drop-down takes me out of the analytic ‘flow’ that Tableau wants me to be in.
But it totally works - if you have the patience for it. But I’m here to save your patience by giving you another solution via…

DYNAMIC PARAMETERS!!!

This is actually shockingly simple, so don’t blink as you might miss it.  It actually comes from knowing a little bit about how URL parameters work.  You may have used these before to create some customize links, or if you have ever written a blog or embedded a dashboard inside of a webpage you tend to learn a thing or two on this.  And Tableau’s documentation is very clear on how these work:

Here we learn first about how we can set parameters in our workbook by putting that value into the URL, like so (parameters and parameter values in purple):

https://servername/views/workbook/sheet?param1=value1,value2&param2=value

and just a little bit farther down from there we come to find out that we can also set field values from our data or calculated fields in a similar way (calc fields and field values in orange):

https://<servername>/views/CoffeeSales/SalesPerformance?Product%20Type=Espresso&Market=East

These are both very interesting pieces of information but neither is extraordinarily groundbreaking. The question that I’ve never seen anyone ask is what happens if I take a parameter value and set equal to a field value - from the examples above something like this:

https://<servername>/views/CoffeeSales/SalesPerformance?param1=Espresso&param2=East

By Joe that’s crazy! If only there was an easy way to do that :) Well of course there is - it’s our dear friend the URL action. You see making a URL action with a link that looks like the following would actually create the URL you saw above:

https://<servername>/views/CoffeeSales/SalesPerformance?param1=<Product Type>&param2=<Market>

By the way - if you’ve always wondered what the checkbox on URL actions that says ‘URL Encode Data Values’ was all about, now is your time to find out, because you definitely want to check the box when you go with this solution.  It’s what handles funny characters like spaces when you have to put them into a URL.  Here’s some more details if you’re curious:

So what we’re saying is you can dynamically set the value of the parameter by clicking on point in the data and using a URL action to set the parameter equal to the point in the data.  They are dynamic because you set their values when you click on them.  They are cascading because of the filter logic you’re using on each sheet that shows the relevant data for the current level of the hierarchy.  And they’re drillable both in and out (we’ll show you how in a bit).  Thus, ladies and gentlemen – I give you:

CLICKABLE, DRILLABLE CASCADING DYNAMIC PARAMETERS IN TABLEAU!!!


I know - where has this been all my life?

I’m now going to walk you through how I built a second, more elegant solution which leverages this URL parameter hack using super store sales data. One big thing to note before we get started – In the first solution we created two parameters that were both LISTS of strings based on the values of Department and Category from the data.  In the solution that follows (and in your solution) I recommend blank string parameters that can be set to ANY value to accomplish the functionality we’re going to discuss here. The advantage is that, of course as your data changes there is no need to update some list of parameters in your workbook.  Also note that you don’t need to create a parameter for the lowest level of the hierarchy, which in my example is Item (Remember SuperStore is Department>>Category>>Item).

The How-To

To begin we need to create three sheets, one at each of the hierarchy used that we care about. Remember the goal of the view the hierarchy is to show two levels at a time - a single parent and all of its associated children. Also note that in each example were looking at a year-over-year change (by quarters if you’re following along with me). I’ll show you how to make the first one, and the other two you can make following the exact same methodology.

First we’ll create our year-over-year metric - it’s a Table Calc using the lookup function. We’re going to compare the current value to the one from four quarters prior and take the percent difference:


Once that calc field is created it’s time to make the first view – this will be Y/Y change in Sales (by quarter and Table Calc using the default of Table Across (Quarter[Order Date])) at the first two levels of detail:  Total SuperStore (one thick grey line) and by Department (three colorful thin lines).  Leveraging a dual axis (don’t forget to sync them) at those two different levels of detail and it should look something like this:


Note the two different levels of detail in each of the dual axis:



Got it? Perfect.  You’re done creating the first level.  Add in any additional formatting/tool tip cleanup and then duplicate the sheet. I’ve called this first sheet ‘1LevelBlank’ so that I know it’s the first level in my drill down.

In the duplicated sheet (‘2LevelBlank’) drill down one level of detail on both of the dual axis – meaning the axis that showed Total Superstore now shows the level of Department, and the axis that originally Department now goes to Category.  Now given that we haven’t talked about filtering yet, you’re looking at about 20 lines (3 Departments and 17 Categories).   It’s a mess.  Don’t worry, we’ll fix it.  Go ahead and duplicate it one more time (‘3LevelBlank’), this time taking the two different levels of detail down to Category and Item (the lowest level for our example).  If you thought the 3 Departments and 17 Categories were a mess, then this is an absolute disaster.  Again, don’t worry, we’re about to fix it. Now that our three sheets are created, let’s go ahead and create our parameters and filters.

Parameters and Filtering

As noted earlier, the easiest thing to do is to create two blank string parameters and set their default values to be blank.  In this example, I’ve named the two parameters: 1DeptBlankParam and 2CategoryBlankParam.  Here’s an example:



Creating the filtering is really simple as well. We’re simply going to match the parameters we created above up with the fields from the data.  Here’s an example:




Now, the first sheet, ‘1LevelBlank’, doesn’t require any filtering, so let’s head to the sheet on the second level, ‘2LevelBlank’.  On the filter shelf add the filter we just created where [1DeptBlankParam]=[Department].  Because the parameter is blank, set the filter to exclude False (ends up doing the same as keeping only True).



Go to the last sheet, ‘3LevelBlank’, and add the filter for [2CategoryBlankParam]=[Category].  Filter it the same as before, excluding False.  When adding the filter on sheets 2 and 3, they should disappear – if they don’t it’s because your blank parameters aren’t really blank.  To test if you’ve done everything right, show the ‘1DeptBlankParam’ parameter and type in ‘Technology’ – you should see some lines show up on the 2LevelBlank Sheet.  If that worked, type in ‘Copiers and Fax’ in to the ‘2CategoryBlankParam’ parameter – and you should see some lines show up on the 3LevelBlank Sheet.  Once you’ve both successfully, clear both parameters and move on to the hack that brings it all together.

The Hack

Now, you’re all probably very familiar with the fact that you can create actions on dashboards.  Should this be news to you, please go and check out Peter Gilk’s great post on Dashboard Actions http://paintbynumbersblog.blogspot.com/2014/10/a-rough-guide-to-tableau-dashboard.html - well done and rather comprehensive.  The interesting thing that most people don’t know is that basically all of these same actions dashboard actions can be done in the worksheet view.  Since we’re all about trying new things, we’ll take this road less traveled and add some worksheet actions.

We’ve already discussed that URL Actions are going to play a key role, so on the first sheet, 1LevelBlank, go up to the top and select Worksheet>>Actions



You’ll be greeted by a very similar action menu that should look very familiar.  Click Add Action>>URL.  This is where we get fancy.  Since we’re going to create a ‘run on menu’ action, the name of the action is what will show up at the bottom of our tooltip.  In the name field, type: ‘Drill in to ’ and then click on the arrow at the end.  Here, select ‘Department’ which will show the value of the Department you’re hovered over.   

Select only the current sheet in the check boxes, 1LevelBlank.

Head to the URL tab and paste in the following (we’ll dissect it next):

https://public.tableau.com/views/DynamicParameterURL/2LevelBlank?:showVizHome=no&:embed=y&:tabs=no&:linktarget=_self&1DeptBlankParam=<Department>&2CategoryBlankParam=

There’s a lot going on here so let’s talk about each piece so that you understand it.  Understanding all of this is very important because this is how you make it both clickable and dynamic so that everything works.

Let’s start at the beginning:
https://public.tableau.com/views/DynamicParameterURL/2LevelBlank?:showVizHome=no&:embed=y&:tabs=no&:linktarget=_self&1DeptBlankParam=<Department>&2CategoryBlankParam=

This is nothing more than the URL address of sheet ‘2LevelBlank’ on the server.  Remember, you’ll be on the highest level of the hierarchy on sheet ‘1LevelBlank’, so this is going to move you to a different sheet one level down in the hierarchy.  The easiest way to get this URL right is to publish the workbook (either to Tableau Server or to Tableau Public, like I’m doing here).  The format is clear:

http://<server>/views/<workbook>/<sheet>

So you should be able to plug in your values and go.

Next up are some very important URL parameters:

https://public.tableau.com/views/DynamicParameterURL/2LevelBlank?:showVizHome=no&:embed=y&:tabs=no&:linktarget=_self&1DeptBlankParam=<Department>&2CategoryBlankParam=

They’re all specified here: http://onlinehelp.tableau.com/current/server/en-us/help.htm#embed_list.htm

The ? means we’re going to add some details (parameters) to the URL. The : that follows it means that the detail is for how to render on the server (without the :, shows that we’re setting a value in the workbook either as a filter or parameter – which we’ll do at the end of this).

:showVizHome=no

This gets rid of the header at the top of the viz (that is now rather large in v9).  Here’s an explination by the famous Ben Jones of Tableau Public. https://public.tableau.com/s/blog/2014/03/how-fix-your-iframe

&

It means there something else I want to add to the URL.  Separate each ‘detail’ parameter in the URL with this ‘&’.

 :embed=y

‘Required for URL parameter. Hides the top navigation area, making the view blend into your web page better.’  When they say required, they really mean some of the other URL parameters won’t even work if this isn’t included. Obvious, but worth mentioning.

:tabs=no

Hides tabs, even if you tick the box in the publishing dialog to show the tabs (which you should do in this case).

:linktarget=_self

Specifies he target window name for external hyperlinks.  There’s two options here – ‘_self’ which we use here means open in the same window/tab; the other option ‘_blank’ would open the URL in a new window/tab. Using this will re-spin the viz in the same window/tab, which is the user experience we are looking for.

Now for setting the parameters in the filters:

https://public.tableau.com/views/DynamicParameterURL/2LevelBlank?:showVizHome=no&:embed=y&:tabs=no&:linktarget=_self&1DeptBlankParam=<Department>&2CategoryBlankParam=

As we addressed back in the beginning, the trick that we are doing here is setting the parameter ‘1DeptBlankParam’ to be equal to the department that we click on in the viz.  Here’s what that looks like when we add in purple for the name of the parameter and orange for the field value from the data:

1DeptBlankParam=<Department>

In the last piece we are simply reminding Tableau that we want the second parameter to remain blank. You should now understand all of the pieces of the URL that we’ve created.

Lastly, to the box for ‘URL Encode Data Values’ - this should properly encode any spaces, commas, and other special characters that are in the data.  It is very important that you check this box.

Here’s what everything should look like:



Now, here’s what the drill in URL menu action for the next level down on sheet ‘2LevelBlank’ looks like – the only changes are in bold at the end:

https://public.tableau.com/views/DynamicParameterURL/3LevelBlank?:showVizHome=no&:embed=y&:tabs=no&:linktarget=_self&1DeptBlankParam=<Parameters.1DeptBlankParam>&2CategoryBlankParam=<Category>



What we are doing here is going to a different sheet one step down in the hierarchy (‘3the Department parameter is holding the value that we gave it in the first drill down (we’re reminding it of the value we set it to in the first drill down), while we are setting the value for the category parameter based off the category that we’re clicking on in the viz (just as we did before with Department, one level up).  If you have additional levels in your hierarchy, you would simply continue creating URLs where the previous parameters would hold their values, the current level would set the value of the parameter, and lower levels would remain blank.

Great – now how do I go back up the hierarchy?

If you’re at the bottom level of the hierarch on sheet ‘3LevelBlank’ (which is where you’d be after the step above), then you’d want to do two things: 1) Go to the sheet one step above in the hierarchy (in this case ‘2LevelBlank’ and 2) Clear the parameter ‘2CategoryBlankParam’ while holding the value of the first parameter ‘1DeptBlankParam’.  All you have to do is create a URL that does exactly that:

https://public.tableau.com/views/DynamicParameterURL/2LevelBlank?:showVizHome=no&:embed=y&:tabs=no&:linktarget=_self&1DeptBlankParam=<Parameters.1DeptBlankParam>&2CategoryBlankParam=

Here’s what mine looks like:



If once you’re there and you want to return all the way to the top, do the same process.  You’ll end up with the following:

https://public.tableau.com/views/DynamicParameterURL/1LevelBlank?:showVizHome=no&:embed=y&:tabs=no&:linktarget=_self&1DeptBlankParam=&2CategoryBlankParam=



We’re almost home.

Putting it all together

Now we could simple publish the tabs, and the interactions would pretty much work, but the user would be heading to a different URL with every click.  This isn’t a winning formula.  Instead, we’re going to create a dashboard and put the whole flow inside of it.  This way it’s easily accessible from Tableau Server.

It’s easier than you think – Create a new dashboard and name it whatever you want (mine is called DynamicBlankParamDrill).

Add a web page object and let it take up the entire dashboard. When prompted for the URL, put in the URL for the highest level, with blank parameters:

https://public.tableau.com/views/DynamicParameterURL/1LevelBlank?:showVizHome=no&:embed=y&:tabs=no&:linktarget=_self&1DeptBlankParam=&2CategoryBlankParam=

Now, it’s time to publish and enjoy:




Things to note

First off, you’ve just created a dashboard with a dynamic parameter!  Wahoo!

Now we should talk.  If you’ve made this far and you understand everything we did then you’ve probably already realized some things:

1)      Using this method as outlined requires you to create a different sheet for every level of the hierarchy – This is less than optimal if there are many levels/layers in your organization’s hierarchy.
2)     You can only dynamically drill in and out of one sheet at a time.  This is because you can only send a URL to one web page object on a Dashboard. 
3)     If you’ve played around with the dashboard, you may have figured out that the dynamic setting of a parameter in the web page object doesn’t extend to other parts of the dashboard.  What I mean is that if you have the parameters on the dashboard and the web page embedded – the parameters are only being updated in the web page object, not outside of it.  Think of movies like Inception or The Matrix – The experience was inside, while the person existed outside.  This is no different – Even though I can show the parameters existing on the dashboard, the experience is inside the web object – and they don’t really tie together at all.




Now those seem like big limitations – and they are.  But you can actually overcome them all.  Here’s how:

Advanced Jedi Tricks

At the client where I put this together, I needed to not only be able to go up and down the hierarchy in a sheet, I needed to create a complex dashboard with multiple sheets.  I also had six levels to go up and down – so there was no way I was going to create six highly complicated dashboards, with all the actions and sheet placement, and then reference each one in the URL.  I would have gone insane.  Now that you understand the basic framework from above – and I walk through that basic example in detail so that this advanced use makes sense – I’ll talk about how I make this work on a complex Dashboard.

Parent and Child Dimensions, Filtering, and URL Fields

What you need to be able to do on the fly is to know – based on the parameters I have values for – what level of the hierarchy am I on?  If you know what level you should be on then you can set four very important things that drive everything:

1) The Parent Level
2) The Children Level
3) The Filter
4) The URL Fields


If you go this route and use logic based on the parameters, then you can create a single sheet that can set itself to the correct level of the hierarchy.

Basically we test the parameters to see if they’re blank.  To do this we use the LEN() function (returns a number as the length of a string based of the number of characters) and it looks like this:



Len([1DeptBlankParam])=0 and
Len([2CategoryBlankParam])=0
Now if this is true, we’re at the highest level.  Because there’s three levels to our hierarchy, we’d do this twice more:

Len([1DeptBlankParam])>0 and
Len([2CategoryBlankParam])=0

This puts us one level down.  And….

Len([1DeptBlankParam])>0 and
Len([2CategoryBlankParam])>0

Puts us at the bottom level.  Create each as its own calculated field – it will save you some time later.  If your hierarchy has more levels then build as many of these as you need.

Now we’re going to create Children Dimension – We’re basically going to say ‘when we’re at x-level, that means y-field is the correct spot in the hierarchy’. It’s actually very simple:



if [ShowOnlyBlankLevel1] then [Department]
elseif [ShowOnlyBlankLevel2] then [Category]
elseif [ShowOnlyBlankLevel3] then [Item]
end

The Parent Dim is just like it, except one level up on the hierarchy:



The last thing we need to do is build the filtering.  This is slightly tricky, but you’ll get it quickly:



Now, here’s the awesome thing – You can build as many sheets as you want!  Just make sure you use the Parent and Children Dimensions for your slicing and filter everything on the filter we just created.

When you bring everything in to a dashboard everything will be based on the parameters as they are set.  You’ll create dashboard actions (so that you can apply them to multiple sheets, rather than just one at a time) for the URL links. Note: Instead of referencing different sheets as you did before, you will reference this same dashboard view in the URL – only the Parameters in the URL will change.

This brings up to the last bit of trick-er-a-tion:  You’re URL has to be dynamically created, which means for every click you’re going to set each value, just as we did before. But it was easier before because we manually made the URL based on the sheet we were on, but we don’t have that luxury now that everything comes from the same sheet.  So – We have to create fields that do this for us and then call those fields on any sheet that needs the ability to drill.

I’m sure that was confusing. It will make sense in a minute.

The goal here is to tell the parameters what value they should be set to on a click.  So on a drill in click going from Level 1 to Level 2, the Dept param should be changed to the Dept that was clicked.  When going from Level 2 to Level 3, the Dept param should hold it’s value.  Here’s how to write that:



At the same time, on a drill in click going from Level 1 to Level 2, the Category param should remain blank.  But when going from Level 2 to Level 3, the Category param should should be changed to the Category that was clicked.  And here’s how to write that:



Now, you’re going to need to call those values in the URL, so take both fields and add then to the Tooltip on the ‘All’ marks card:



I’ve also added the way to drill back out (download to see it).

Almost done! Dashboard time – Create a new dashboard (Mine is called ‘FinalDynamicDrillDash’).  Set the size of the dashboard to Automatic and bring in the sheet you just created.  Click on Dashboard actions and select URL Actions.

We’re going to do just as we did before with some moderate tweaks.  The URL is going to be self-referencing and the parameter values are coming from the fields you just created.  It looks like this (note the bold parts:

https://public.tableau.com/views/DynamicParameterURL/FinalDynamicDrillDash?:showVizHome=no&:embed=y&:tabs=no&:linktarget=_self&1DeptBlankParam=<ATTR(URLDeptParam)>&2CategoryBlankParam=<ATTR(URLCategoryParam)>



You’re done with that dashboard for the moment.  Just as we did before, create one last dashboard with just a single web object.  When asked for the starting URL, use the one from above, but remove the parameter fields (we want them to be blank when it loads).  It should look like this:

https://public.tableau.com/views/DynamicParameterURL/FinalDynamicDrillDash?:showVizHome=no&:embed=y&:tabs=no&:linktarget=_self&1DeptBlankParam=&2CategoryBlankParam=

Now publish the whole thing!

If you see any errors just reload the page.

You’re done! Yay!

To prove out the dashboard concept I added a Tree Map sheet as well and allow the user to select either sheet to drill in.

Here’s the final product:



I can’t believe you made it all the way through this post.  Thanks for hanging out.  Hopefully you’ve learned a couple things.  The Analysis that you can do with this is incredibly powerful!  So go out and change the world with your dynamic parameters in Tableau!


Nelson

62 comments:

  1. Great post (as always)! This is some great functionality, and as you mentioned it has been right in front of our face this whole time!

    One question I did have was that when I published this my Tableau Server I navigated to the view and when I click on the URL action created from this post it launches in a new tab even though I have :linktarget=_self in the URL action. Is this because of how I am originally accessing the URL?

    ReplyDelete
    Replies
    1. Hey Nick -
      Thanks for posting! I would check to make sure that you're also including the ' :embed=y' part of the URL as well. The linktarget only works if it's included. Let me know if that doesn't resolve it. Many thanks!

      Delete
    2. Thank you Nelson. From my testing it looks like you if you navigate to the workbook from Tableau Server itself the URL action will pop in a new tab, however if you first access the URL with :linktarget=_self in the query string then everything works beautifully.

      Delete
    3. AM SANDRA FROM CANADA, THANKS TO DR ONIHA WHO HELP ME BRING MY HUSBAND BACK, MY HUSBAND LEFT ME WITH THREE KIDS, FOR ANOTHER YOUNG GIRL, FOR OVER TWO YEARS, I TRIED ALL I COULD TO SETTLED OUR DIFFRENCES, BUT IT YIELDED NO RESULT, I WAS THE ONE TAKING CARE OF THE CHILDREN ALONE, UNTIL ONE DAY, I CAME IN CONTACT WITH SOME ARTICLES ONLINE, CONTAINING HOW DR ONIHA HAS HELP SO MANY LOVERS AND FAMILY REUNION AND REUNIT AGAIN, AND I DECIDED TO CONTACT HIM, AND HE CAST HIS SPELL ON MY HUSBAND, WITHIN FIVE DAYS, MY HUSBAND RAN BACK HOME, AND WAS BEGGING ME AND THE KIDS FOR FORGIVENESS, IN CASE YOU ARE PASSING THROUGH SIMILAR PROBLEMS, AND YOU WANTS TO CONTACT DR ONIHA, YOU CAN REACH HIM VIA HIS CONTACT NUMBER, ON CALL OR WHATSAP +2347089275769 OR EMAIL DRONIHASPELL@YAHOO.COM

      Delete
    4. REAL URGENT EFFECTIVE SPELL CASTER TO HELP BRING BACK EX LOVER AND SAVE MARRIAGE https://doctor0lovespell.wixsite.com/mysite-2
      I want to let the world know about Dr Love0 the Great spell caster that brought back my husband to me when i thought all hope was lost. Dr Love0 used his powerful spell to put a smile on my face by bringing back my man with his spell, at first i thought i was dreaming when my husband came back to me on his knees begging me to forgive him and accept him back and ever since then he loves me more than i ever expected so i made a vow to my self that i will let the World know about Dr Love0 because he is a God on earth. Do you have problems in your relationship ? have your partner broke up with you and you still love and want him back ? Do you have problem with your finance ? or do you need help of any kind then contact Dr Love0 today for i give you 100% guarantee that he will help you just as he helped me. Dr Love0 email:(doctor0lovespell@gmail. com) or visit his website: https://doctor0lovespell.wixsite.com/mysite-2  or contact his FB page: https://www.facebook.com/Lovespellthatworkfastusa  also check his blogs: https://doctorlovespell0.blogspot.com/


















      REAL URGENT EFFECTIVE SPELL CASTER TO HELP BRING BACK EX LOVER AND SAVE MARRIAGE https://doctor0lovespell.wixsite.com/mysite-2
      I want to let the world know about Dr Love0 the Great spell caster that brought back my husband to me when i thought all hope was lost. Dr Love0 used his powerful spell to put a smile on my face by bringing back my man with his spell, at first i thought i was dreaming when my husband came back to me on his knees begging me to forgive him and accept him back and ever since then he loves me more than i ever expected so i made a vow to my self that i will let the World know about Dr Love0 because he is a God on earth. Do you have problems in your relationship ? have your partner broke up with you and you still love and want him back ? Do you have problem with your finance ? or do you need help of any kind then contact Dr Love0 today for i give you 100% guarantee that he will help you just as he helped me. Dr Love0 email:(doctor0lovespell@gmail. com) or visit his website: https://doctor0lovespell.wixsite.com/mysite-2  or contact his FB page: https://www.facebook.com/Lovespellthatworkfastusa  also check his blogs: https://doctorlovespell0.blogspot.com/
















      REAL URGENT EFFECTIVE SPELL CASTER TO HELP BRING BACK EX LOVER AND SAVE MARRIAGE https://doctor0lovespell.wixsite.com/mysite-2
      I want to let the world know about Dr Love0 the Great spell caster that brought back my husband to me when i thought all hope was lost. Dr Love0 used his powerful spell to put a smile on my face by bringing back my man with his spell, at first i thought i was dreaming when my husband came back to me on his knees begging me to forgive him and accept him back and ever since then he loves me more than i ever expected so i made a vow to my self that i will let the World know about Dr Love0 because he is a God on earth. Do you have problems in your relationship ? have your partner broke up with you and you still love and want him back ? Do you have problem with your finance ? or do you need help of any kind then contact Dr Love0 today for i give you 100% guarantee that he will help you just as he helped me. Dr Love0 email:(doctor0lovespell@gmail. com) or visit his website: https://doctor0lovespell.wixsite.com/mysite-2  or contact his FB page: https://www.facebook.com/Lovespellthatworkfastusa  also check his blogs: https://doctorlovespell0.blogspot.com/




      Delete
    5. I want to quickly crave your indulgence and bring to your notice a powerful spell caster called Dr LOVE0 who in just 3 days of contact was able to bring back my lost love am short of words to thank him and i have resort to this medium of telling the world at large about him. His truly amazing and kind contact him today via Email: doctor0lovespell@gmail.com or check his blogs: https://doctorlovespell0.blogspot.com/ or visit his FB page: https://www.facebook.com/Lovespellthatworkfastusa  .He is also able to cast spells like
      1:Pregnancy Spell
      2:Jail Release
      3:Prosperity Spell
      4:Lottery Spell
      5:Cancer cure ETC......













      I want to quickly crave your indulgence and bring to your notice a powerful spell caster called Dr LOVE0 who in just 3 days of contact was able to bring back my lost love am short of words to thank him and i have resort to this medium of telling the world at large about him. His truly amazing and kind contact him today via Email: doctor0lovespell@gmail.com or check his blogs: https://doctorlovespell0.blogspot.com/ or visit his FB page: https://www.facebook.com/Lovespellthatworkfastusa  .He is also able to cast spells like
      1:Pregnancy Spell
      2:Jail Release
      3:Prosperity Spell
      4:Lottery Spell
      5:Cancer cure ETC......


      Delete
    6. My Name Ollis Bator from TX USA. After 12years of marriage, me and my husband have been into one quarrel or the other until he finally left me and moved to California to be with another woman. I felt my life was over and my kids thought they would never see their father again. I tried to be strong just for the kids but I could not control the pains that tormented my heart, my heart was filled with sorrows and pains because I was really in love with my husband. Every day and night I think of him and always wish he would come back to me, I was really upset and I needed help, so I searched for help online and I came across a website that suggested that Dr. Wale can help get ex back fast. So, I felt I should give him a try. I contacted him and he told me what to do and I did it then he did a Love spell for me. 24 hours later, my husband really called me and told me that he missed me and the kids so much, So Amazing!! So that was how he came back that same day, with lots of love and joy, and he apologized for his mistake, and for the pain he caused me and the kids. Then from that day, our Marriage was now stronger than how it was before, All thanks to Dr. Wale. he is so powerful and I decided to share my story on the Internet with Dr. Wale real and powerful spell caster who I will always pray to live long to help his children in the time of trouble, if you are here and you need your ex back or your husband moved to another woman, do not cry anymore, contact this powerful spell caster now. Here's his WhatsApp number +1(978) 406-9575 or Email him : everlastingspellcast@gmail.com or view his website for more review https://everlastingspellcaster.website2.me/contact    
































































      My Name Ollis Bator from TX USA. After 12years of marriage, me and my husband have been into one quarrel or the other until he finally left me and moved to California to be with another woman. I felt my life was over and my kids thought they would never see their father again. I tried to be strong just for the kids but I could not control the pains that tormented my heart, my heart was filled with sorrows and pains because I was really in love with my husband. Every day and night I think of him and always wish he would come back to me, I was really upset and I needed help, so I searched for help online and I came across a website that suggested that Dr. Wale can help get ex back fast. So, I felt I should give him a try. I contacted him and he told me what to do and I did it then he did a Love spell for me. 24 hours later, my husband really called me and told me that he missed me and the kids so much, So Amazing!! So that was how he came back that same day, with lots of love and joy, and he apologized for his mistake, and for the pain he caused me and the kids. Then from that day, our Marriage was now stronger than how it was before, All thanks to Dr. Wale. he is so powerful and I decided to share my story on the Internet with Dr. Wale real and powerful spell caster who I will always pray to live long to help his children in the time of trouble, if you are here and you need your ex back or your husband moved to another woman, do not cry anymore, contact this powerful spell caster now. Here's his WhatsApp number +1(978) 406-9575 or Email him : everlastingspellcast@gmail.com or view his website for more review https://everlastingspellcaster.website2.me/contact    

      Delete
  2. Great post Nelson! I had built a few workbooks with custom "dynamic parameters" using URL actions for a couple of customers in the past but this takes it to a whole new level with cascading filters. Not to mention the awesome, detailed writeup.

    ReplyDelete
  3. Great post as usual Nelson!!

    You approach of setting parameters via URL action looks like a promising solution to our problem:
    Most of our dashboards have a FROM & TO date selection and the users want it to be set to Last Week/Fortnight/Month by default when they access via Tableau Server. So i'll give this approach a try. :)

    ReplyDelete
  4. Dude this is epic. I combined this with Dynamic Hierarchies and this report is oozing with goodness. The one suggestion I have for anyone that is duplicating this is to add one more thing to Filter - Parent Child. The last line should say:
    ([ShowOnlyBlankLevel3] AND [2CategoryBlankParam] = [Category] AND [1DeptBlankParam] = [Department])

    This will let you put things that aren't actually a hierarchy into this structure. If you leave it as the author has it and there are similar Categories that belong to different Departments then the numbers will be wrong when you drill down to Department level.

    ReplyDelete
  5. Oops above comment should say "numbers will be wrong when you drill down to Category level."

    ReplyDelete
  6. Hi Nelson,

    Great post and awesome explanation.

    I need your help as I have two bar charts in which I am applying the Parent_child_method to drill down individual for both the worksheets.
    So when I drill down in the first worksheet till the last level and when I drill the second worksheet all the filters are removed from the first worksheet.

    Both the worksheet have different hierarchies.
    Hope it makes sense.

    ReplyDelete
  7. Great post Nelson. Keep up the good work!

    ReplyDelete
  8. Enpersol offers Tableau Consulting Services, specializing in implementation and dashboarding in pune and indore. also help you, whether you're just starting out with Tableau, or you need some advanced expertise.

    ReplyDelete
  9. Excellent post**this helped me alot

    ReplyDelete
  10. This comment has been removed by the author.

    ReplyDelete
  11. This comment has been removed by the author.

    ReplyDelete
  12. Awesome post.Comprehensive knowledge has been gained regarding Tableau.
    For more details please visit here:
    Tableau Training in Hyderabad

    ReplyDelete
    Replies
    1. MY LOVER IS BACK...
      My name is Ronald Monica from USA. I am really pleased with this service. I am one of those people who said, “I’ll never call a psychic or a magician or whatever” to help me with my problems – least of all my love problems, but I reached the point where I knew I needed some guidance, and I’m so glad I found this man called Dr balbosa, I never in a million years would have thought I’d be writing a letter like this, but when I nearly lost Andrew, my love in one of our stupid, fights (he broke up with me), I thought I had lost everything. i cry all day and think that he will never come back to me again. I read a testimony by a man called Tyce Logan about him saying how Dr balbosa helped him to get back is ex wife within 48 hours .I quickly email Dr balbosa and explained everything to him And when I was at my most desperate situation he didn’t take advantage of me. Dr Balbosa is the best and genuine spell caster. He performed a very good service for a person in true need. I don’t know how you did it, or how this magic works, but all I know is, IT WORKS!! Andrew, my husband and I are happily back together, and I’ll always be grateful to Dr balbosa...
      don't fail to contact him for any kind of help, Dr balbosa is very capable and reliable...From Monica

      CONTACT HIM ON:
      CALL/WHATSAPP: +1(206)-485-3691
      WEBSITE: https://balbosasolutionhome.com
      EMAIL: balbosasolutionhome@gmail.com  











      MY LOVER IS BACK...
      My name is Ronald Monica from USA. I am really pleased with this service. I am one of those people who said, “I’ll never call a psychic or a magician or whatever” to help me with my problems – least of all my love problems, but I reached the point where I knew I needed some guidance, and I’m so glad I found this man called Dr balbosa, I never in a million years would have thought I’d be writing a letter like this, but when I nearly lost Andrew, my love in one of our stupid, fights (he broke up with me), I thought I had lost everything. i cry all day and think that he will never come back to me again. I read a testimony by a man called Tyce Logan about him saying how Dr balbosa helped him to get back is ex wife within 48 hours .I quickly email Dr balbosa and explained everything to him And when I was at my most desperate situation he didn’t take advantage of me. Dr Balbosa is the best and genuine spell caster. He performed a very good service for a person in true need. I don’t know how you did it, or how this magic works, but all I know is, IT WORKS!! Andrew, my husband and I are happily back together, and I’ll always be grateful to Dr balbosa...
      don't fail to contact him for any kind of help, Dr balbosa is very capable and reliable...From Monica

      CONTACT HIM ON:
      CALL/WHATSAPP: +1(206)-485-3691
      WEBSITE: https://balbosasolutionhome.com
      EMAIL: balbosasolutionhome@gmail.com  

      Delete
  13. Enpersol Technologies provide best Odoo and Tableau services, SAP consulting and implementation, SAP custom development in pune and indore.

    ReplyDelete
  14. Hi Nelson,
    Thanks for the great post. I am able to achieve most of the functionality following the steps. One issue I am facing is how to hide Go Back Link on first hierarchy and Drill into in the last hierarchy using the single worksheet option

    ReplyDelete
  15. I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work..

    Tableau online training hyderabad

    ReplyDelete

  16. the blog is about Clickable Drillable Cascading Dynamic Parameters in Tableau it is useful for students and python for more updates on python follow the link
    tableau online training hyderabad

    For more info on other technologies go with below links

    ServiceNow Online Training

    mulesoft Online Training

    Python Online Training

    ReplyDelete


  17. well done! the blog is good and it is about Drillable Cascading Dynamic Parameters in Tableau is useful for students and tableau Developers for more updates on Tableau follow the link

    tableau online training Bangalore

    For more info on other technologies go with below links

    Python Online Training

    ServiceNow Online Training

    mulesoft Online Training

    ReplyDelete
  18. This comment has been removed by a blog administrator.

    ReplyDelete
  19. There are several ways to bet back an ex, but the simplest and safest should be what you should aim for. Why suffer endless heartbreak from those whom you love but don't love you return, why share tears when your ex have already moved on leaving your heart crashed to the dust?, do you have any relationship issues which you really need solutions to?, having nightmares, or any other problems which is currently eating your joy up physically, mentally and spiritually? if YES to any of this, i advise you seek help and guide from a powerful psychic and spell caster called Dr Henry. I personally recommend this great and real voodoo spell caster Dr Henry to everyone who needs Ex Back, Money Spell, Lottery Spell, Gambling Spell, Death or Revenge Spell, Beauty Spell, Spiritual Protections and Pregnancy Spell. He have helped me return my Husband after 2 years of separation and its been 7 years now since he helped me return my husband back, my husband have loved and cherished me all this while. You should also reach Dr Henry on PERMANENTSPELLCAST@YAHOO.COM or +2348100663964

    ReplyDelete
  20. It is really a great work and the way in which you are sharing the knowledge is excellent.Tableau Training in Chennai

    ReplyDelete
  21. My testimony on how i won £4,000,000 with the great help of Dr Davi powerful lottery spell: Call him +55 (11) 97732-4658   
    It's unbelievable how fortunate I feel after finding your website. For the past 14 years, I have been looking for a way on how i will win lottery. Money situation was one of the biggest problem to me. I had a huge amount of debt and I didn't know what to do. Out of complete and total desperation, I contacted many of those so-called individuals who promised powerful magic to win the lottery, witchcraft or black magic. None of them worked and none were as wonderful, affectionate and warm as Dr Davi has been. He is definitely different from the others and I felt immediate hope and strength from hearing about the promises he had to offer. He carries an air of purity and divine strength that is as pure as fresh snow on the ground. I requested Dr Davi most powerful spells and I was relieved right away that I had someone to solve my problems for me. His spells worked wonders,i won (Four Million pounds) my money troubles resolved itself after winning the lottery. My life change over night,i now have my own house and two cars,also i am free from my debts. Dr Davi, I have no idea what I would have done without you being there to help me out. If you are there and you need a powerful magic to win the lottery,Dr. Davi is the right person you need to trust and work with,i promise you that you will also win and share your own testimony. You can contact him via email:

    Spelltemple@fastmail.com Call or text him +55 (11) 97732-4658 

    ReplyDelete
  22. This comment has been removed by the author.

    ReplyDelete
  23. Well article, interesting to read…
    Thanks for sharing the useful information
    Pega Online Training

    ReplyDelete
  24. Nice article, interesting to read…
    Thanks for sharing the useful information
    pega certification

    ReplyDelete
  25. Nice to see your blog and most beautiful images. Am waiting your next valuable blog.
    I want like to share some information with you About the On Job Support.

    ReplyDelete
  26. Awesome post. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion HCM Training

    ReplyDelete
  27. Welcome to brotherhood Illuminati where you can become rich famous and popular and your life story we be change totally my name is Harrison I am here to share my testimony on how I join the great brotherhood Illuminati and my life story was change immediately . I was very poor no job and I has no money to even feed and take care of my family I was confuse in life I don’t know what to do I try all my possible best to get money but no one work out for me each day I share tears, I was just looking out my family no money to take care of them until one day I decided to join the great Illuminati , I come across them in the internet I never believe I said let me try I email them.all what they said we happen in my life just started it was like a dream to me they really change my story totally . They give me the sum of $8,000,000 and many thing. through the Illuminati I was able to become rich, and have many industry on my own and become famous and popular in my country , today me and my family is living happily and I am the most happiest man here is the opportunity for you to join the Illuminati and become rich and famous in life and be like other people and you life we be change totally.If you are interested in joining the great brotherhood Illuminati you can contact us. on whatApp ofcall   +2348166545531      

    ReplyDelete
  28. i am ERIC BRUNT by name. Greetings to every one that is reading this testimony. I have been rejected by my wife after three(3) years of marriage just because another Man had a spell on her and she left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address AKHERETEMPLE@gmail.com have help a woman to get back her husband and i gave him a reply to his address and he told me that a man had a spell on my wife and he told me that he will help me and after 3 days that i will have my wife back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my wife. Thanks for helping me Dr Akhere contact him on email: AKHERETEMPLE@gmail.com
    or
    call/whatsapp:+2349057261346










    i am ERIC BRUNT by name. Greetings to every one that is reading this testimony. I have been rejected by my wife after three(3) years of marriage just because another Man had a spell on her and she left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address AKHERETEMPLE@gmail.com have help a woman to get back her husband and i gave him a reply to his address and he told me that a man had a spell on my wife and he told me that he will help me and after 3 days that i will have my wife back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my wife. Thanks for helping me Dr Akhere contact him on email: AKHERETEMPLE@gmail.com
    or
    call/whatsapp:+2349057261346


    ReplyDelete
  29. Your article is awesome! How long does it take to complete this article? I have read through other blogs, but they are cumbersome and confusing. I hope you continue to have such quality articles to share with everyone! I believe there will be many people who share my views when they read this article from you!

    Data Science Training in Hyderabad

    Hadoop Training in Hyderabad

    Java Training in Hyderabad

    Python online Training in Hyderabad

    Tableau online Training in Hyderabad

    Blockchain online Training in Hyderabad

    informatica online Training in Hyderabad

    devops online Training

    ReplyDelete
  30. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.


    Big Data and Hadoop Online Training
    Big Data Hadoop Training
    Hyderabad

    ReplyDelete
  31. What a beautiful and wonderful testimony, sometimes things you don't believe can just happen. My name is Adams Vera, from U.S.A am 28 years old i got married at the age of 24 i have only one child and i was living happily. After three years of my marriage my husband behavior became so strange and i don't really understand what was going on, he packed out of the house to another woman i love him so much that i never dreamed of losing him, i try my possible best to make sure that my husband get back to me but all to no avail i cry and i cry seeking for help because i was heart broken until i coincidentally came across an online spell caster called Dr. Osasu , i contacted him and explained to him what i have been going through in my marriage and he gave me the full assurance that my husband will come back to me and my marriage will be restored, He told me what to do to get my husband back and i did, he said after 3days my husband will come back to me and start begging, it really happen it was so surprising and everything was just like a miracle, ever since my family have been living with so much happiness and our relationship was now very tight because of this great and powerful spell caster.he is a very great and powerful spell caster that can be trusted and there is nothing concerning life issues he cannot solve because i am a living testimony. i know there are so many people out there who are going through similar problems in one way or the other, believe me this is the right spell caster to contact and all your problems will be forgotten. contact Dr. Osasu viaWhatsapp: +2347064365391 Email:Account drosasu25@gmail.com

    ReplyDelete
  32. HOW DR. UNEME brought back my ex lover unemespellben@gmail.com
    Am DONNA, am from UK. After been in a relationship with my Boyfriend for 1 year now and we were planning to get married soon and all of a sudden he left me for another girl. of a truth, I really love this guy and never can I imagine life without him. I further tried all my best to get him back but all my effort to get him back in my life did not work out. It was on this faithful day, I came across some Testimonies on a website about this great spell caster called (Dr. UNEME) any persons claimed that he help them to renew their relationship and bring their ex lover back, I had to contact him because he was my last hope. I contacted him through his email and he assured me that in three days time my boyfriend is going to leave the other girl and come back to me and it was a very great surprise to see my boyfriend coming back to me after three days the spell was done. I am so very happy today that he came back to me and i achieved this with the help of Dr UNEME I equally want to use this opportunity to Tell/Advice to as many who need their ex back, if you need his help you can Contact him through
    EMAIL: unemespellben@gmail.com WHATSAPP HIM @ +2348143813120


    Thank You Once Again Dr.UNEME


    ReplyDelete
  33. The article is so appealing. You should read this article before choosing the Big data solutions developer you want to learn.

    ReplyDelete
  34. My ex-husband and I had always managed to stay friendly after our divorce in February 2017. But I always wanted to get back together with him, All it took was a visit to this spell casters website last December, because my dream was to start a new year with my husband, and live happily with him.. This spell caster requested a specific love spell for me and my husband, and I accepted it. And this powerful spell caster began to work his magic. And 48 hours after this spell caster worked for me, my husband called me back for us to be together again, and he was remorseful for all his wrong deeds. My spell is working because guess what: My “husband” is back and we are making preparations on how to go to court and withdraw our divorce papers ASAP. This is nothing short of a miracle. Thank you Dr Emu for your powerful spells. Words are not enough. here is his Email: emutemple@gmail.com or call/text him on his WhatsApp +2347012841542 

    ReplyDelete
  35. Am sharing this testimony to partners suffering in their relationships because there is an enduring solution. My husband left me and our 4 kids for another woman for 1 year. I tried to be strong just for my kids but I could not control the pains that torment my heart. I was hurt and confused. I needed a help, so i did a research on the internet and came across a site where I saw that Dr. Godday a spell caster,who can help get lot lovers back within few hours I contacted him and he did a special prayer and spells for me. To my surprises, after few days, my husband came back home. That was how we reunited again and there was a lot of love, joy and peace in the family. You can as well contact Dr. Godday, a powerful spell-caster for solutions on his contact Email: goddayspiritualhome@gmail.com Whats app only +1{919}4956404

    ReplyDelete


  36. ***PLEASE READ***  From the bottom of my heart, I can never thank you enough DR.BALBOSA for the wonderful work you did for me and my kids to bring back my husband. Am stella Andre from England. I was having serious relationship problems with my husband and he was no longer committed to me and our kids, when i asked him what the problem was he told me he has fell out of love for me and wanted a divorce and  i was so heart broken, i cried all day and night, it had resulted in him moving out to his friend’s apartment. Everything got worse because he started going to bars and strip clubs frequently with his friend, getting drunk and passing out. He always threatens me on the phone whenever I call him because of all the bad advice that his friend has given him. I really love him and we had been married for 8 years which gave us a beautiful daughter and a son. I had also lost a lot of money on therapists until I was introduced to DR. BALBOSA by a friend whom he helped to marry her childhood boyfriend, this gave me total confidence and strength to get him back. I did all that DR. BALBOSA asked me to do it and I also followed all instructions given to me by DR. BALBOSA to my greatest surprise after 48 hours my husband called me and rushed back home with a brown new car for me and our kids... things just changed between us emotionally, I was the happiest woman on earth that day. my husband now has a good job and stopped drinking and he stopped keeping irrelevant friends. It’s a miracle I never believed was possible because I had lost all hope until I found DR. BALBOSA...contact him today and get your love back i can assure you .... contact him on his Email on: balbosasolutionhome@gmail.com and CALL/ WHATSAPP: +2347048047728...BYE... 

    ReplyDelete
  37. HOW I GOT BACK MY EX WITH THE HELP OF DR OGAGA CONTACT HIM ON WHATSAPP +2347059387282

    I want to quickly tell the world that there is a real online spell caster that is powerful and genuine, His name is Dr Ogaga, He helped me recently to reunite my relationship with my husband who left me, When i contacted Dr Ogaga he cast a love spell for me and my husband who said he doesn't have anything to do with me again called me and started begging me. he is back now with so much love and caring. today i am glad to let you all know that this spell caster have the powers to bring lovers back. because i am now happy with my husband. To anyone who is reading this article and needs any help, Dr. Ogaga can also offer any types of help like Reuniting of marriage and relationship, love spell, ex back and lot's more. You can contact him via this email ogagaspellcastertemple@gmail.com or WhatsApp +2347059387282

    ReplyDelete
  38. I am here to give my testimony about Dr Ebhota who helped me.. i want to inform the public how i was cured from (HERPES SIMPLEX VIRUS) by salami, i visited different hospital but they gave me list of drugs like Famvir, Zovirax, and Valtrex which is very expensive to treat the symptoms and never cured me. I was browsing through the Internet searching for remedy on HERPES and i saw comment of people talking about how Dr Ehbota cured them. when i contacted him he gave me hope and send a Herbal medicine to me that i took for just 2 weeks and it seriously worked for me, my HERPES result came out negative. I am so happy as i am sharing this testimony. My advice to you all who thinks that there is no cure for herpes that is Not true just contact him and get cure from Dr Ebhota healing herbal cure of all kinds of sickness you may have like (1) CANCER,(2) DIABETES,(3) HIV&AIDS,(4) URINARY TRACT INFECTION,(5) CANCER,(6) IMPOTENCE,(7) BARENESS/INFERTILITY(8) DIARRHEA(9) ASTHMA(10)SIMPLEX HERPES AND GENITAL(11)COLD SOREHERPES. he also cure my friend from cervical cancer Email: drebhotasoultion@gmail.com or whatsapp him on +2348089535482

    ReplyDelete
  39. Life has been so miserable after my boyfriend broke up with me 6 months ago. I never thought he could hurt me just like that then i realized how much i loved my boyfriend when he ended our relationship and i had to look for options to make sure i get her back to myself for i wasn't living fine anymore. I was directed to a Spell Doctor known as Dr Mamudu by my cousin who he claimed he helped him in winning a lottery. I made contact with the Doctor and i was surprised and amazed when my boyfriend came back to me with he knees on the floor pleading to me for forgiveness to take he back as my lover. I thought i was dreaming because all this happened just within 24 hours and it happened as the spell Doctor as said. For that wonderful encounter with this man, i took a decision on my path that i will let the world know about Dr Mamudu for he's able and capable to solve any problems. Get in touch with him drmamudu47@gmail. com bless Dr Mamudu l love you or add him on Whats-app: +2348143284524

    ReplyDelete
  40. I am so happy to share this fantastic testimony of mine. My life has changed completely in 48hours. I can see myself in the mirror and smile. I have confidence in myself and my abilities for the first time in ages. I have my husband back in my life with the help of Dr Oniha. He said sorry after 24hours, after the spell was created. He said he realized that he never really wanted to break up; he could not handle the emotional baggage I was carrying around all the time. He said that he thought he was the negative influence in my life and thought it best to leave. He said it was hard that I kept talking about the past all the time. We have both forgiven each other. I have money in my pocket that is my own at last. (My compensation cheque came through and I was told it was months away. I am living proof of what Dr Oniha can do. I thank you so much Dr Oniha for the wonderful thing you did in my marriage. I am so happy now. With your help we were both able to see and speak the truth to each other. I never thought a spell could help a couple before I am very pleased to contact you and initiate all this to happen. Anyone who has a relationship problem can contact Dr Oniha.
    Email: onihaspelltemple@gmail.com
    Call/Whatsapp number: +16692213962
    Website: http://onihaspells.com

    ReplyDelete
  41. I am so happy to share this fantastic testimony of mine. My life has changed completely in 48hours. I can see myself in the mirror and smile. I have confidence in myself and my abilities for the first time in ages. I have my husband back in my life with the help of Dr Oniha. He said sorry after 24hours, after the spell was created. He said he realized that he never really wanted to break up; he could not handle the emotional baggage I was carrying around all the time. He said that he thought he was the negative influence in my life and thought it best to leave. He said it was hard that I kept talking about the past all the time. We have both forgiven each other. I have money in my pocket that is my own at last. (My compensation cheque came through and I was told it was months away. I am living proof of what Dr Oniha can do. I thank you so much Dr Oniha for the wonderful thing you did in my marriage. I am so happy now. With your help we were both able to see and speak the truth to each other. I never thought a spell could help a couple before I am very pleased to contact you and initiate all this to happen. Anyone who has a relationship problem can contact Dr Oniha.
    Email: onihaspelltemple@gmail.com
    Call/Whatsapp number: +16692213962
    Website: http://onihaspells.com

    ReplyDelete
  42. I am so happy investing with Carlos Trading Signal.. He has really helped after I lost my job. I started investing as little as $200 and now I earn over $2,500 weekly. So happy you can contact him on his Email: carlose78910@gmail.com
    Via whatsapp: (+12166263236)

    ReplyDelete
  43. I am so happy investing with Carlos Trading Signal.. He has really helped after I lost my job. I started investing as little as $200 and now I earn over $2,500 weekly. So happy you can contact him on his Email: carlose78910@gmail.com
    Via whatsapp: (+12166263236)

    ReplyDelete
  44. I am so happy to share this fantastic testimony of mine. My life has changed round completely in 48hours. I can see myself in the mirror and smile. I have confidence in myself and my abilities for the first time in ages. I have my boyfriend back in my life with the help of Dr Oniha. He said sorry a 24hours after the spell was created. He said he realised that he never really wanted to break up he could not handle emotional baggage I was carrying around all the time. He said that he thought he was the negative influence on my life and thought it best to leave. He said it was hard that I kept talking about the past all the time. We have both forgiven each other. I have money in my pocket that is my own at last. (My compensation cheque came through I was told it was months away. I am living proof of what Dr Oniha can do. I thank you so much Dr Oniha for the wonderful thing you did in my relationship. I am so happy now. With your help we were both able to see and speak the truth to each other. I never thought a spell could help a couple before I am very pleased contacted you and initiated all this to happen. Anyone who have a relationship problem can contact Dr Oniha.
    EMAIL:ONIHASPELLTEMPLE@GMAIL.COM
    WEBSITE http://onihaspells.com
    Call/Whatsapp number: +16692213962

    ReplyDelete
  45. DO YOU NEED A PERSONAL/BUSINESS/INVESTMENT LOAN? CONTACT US TODAY VIA WhatsApp +19292227023 Email drbenjaminfinance@gmail.com

    HELLO
    Loan Offer Alert For Everyone! Are you financially down and you need an urgent credit/financial assistance? Or are you in need of a loan to start-up/increase your business or buy your dream house. Are you tired of Seeking Loans and Mortgages? Have you been turned down by your banks? Have you also been scammed once? Have you lost money to scammers or to Binary Options and Cryptocurrency Trading, We will help you recover your lost money and stolen bitcoin by our security FinanceRecovery Team 100% secured, If you are in financial pains consider your financial trauma over. We Offer LOANS from $3,000.00 Min. to $30,000,000.00 Max. at 2% interest rate NO MATTER YOUR CREDIT SCORE. GET YOUR INSTANT LOAN APPROVAL 100% GUARANTEED TODAY VIA WhatsApp:+19292227023 Email: drbenjaminfinance@gmail.com

    ReplyDelete
  46. TRUTH BE TOLD!!! There are no perfect relationships. If you truly care and love your partner, don't fight him or her.. instead, fight to keep him/her. This was exactly what I did and with the help of Dr Akhigbe my ex returned back to me and I believe there a lot of people going through heartbreak, Dr Akhigbe can also help you. Email drakhigbespellhome7@gmail.com you can also call him or add him on Whats-app: +2349021374574

    ReplyDelete
  47. TheMendix app storeis a collection of reusable modules and apps that can be quickly incorporated into your mendix projects. It is a one-stop shop for building great enterprise apps without the hassle of having to build everything from scratch.

    ReplyDelete
  48. OMG!!! I am so proud and happy to be out here sharing your work with Dr. Sam. I just can't believe that now my ex Husband is really back to me on his knees presenting a ruby rose to beg me to take him back and he was feeling regretful and sorry for leaving me and for causing me pains after the divorce which occurred last year. And this whole miracle happened after I ordered an urgent 21hours Dr. Sam powerful spell which he cast on me and my husband. Sir, I am the happiest woman today in this whole wide world. Dr. Sam, you really did it..Yes.. It's a miracle and an everlasting pleasure and cheerfulness for me and my family today.. I am so happy now and I don't know how much to convey my thankfulness and appreciation to you sir. And to the whole world, contact him if you need urgent help now because it's guaranteed that he will help you.

    E-mail:: Supremespellcast@gmail.com Or Supremespellcast@yahoo.com
    Add him up on WhatApp Him ‪+1 (631)320-5873‬
    His Blog:: https://supremespellcast.blogspot.com/
    Via his Page::: https://www.facebook.com/supremespellcast.12
    Do accept my gratitude sir.

    ReplyDelete
  49. GET OUT OF FINANCIAL MESS WITH THE HELP OF drbenjaminfinance@gmail.com

    I have been in financial mess for the past months, I’m a single mum with kids to look after. My name is REBECCA MICHAELSON, and am from Ridley Park, Pennsylvania. A couple of weeks ago My friend visited me and along our discussion she told me about DR BENJAMIN OWEN FINANCE of (drbenjaminfinance@gmail.com); that he can help me out of my financial situation, I never believed cause I have spend so much money on different loan lenders who did nothing other than running away with my money. She advised, I gave it a try because she and some of her colleagues were rescued too by this Godsent lender with loans to revive their dying businesses and paying off bills. so I mailed him and explain all about my financial situation and therefore took me through the loan process which was very brief and easy.. After that my loan application worth $278,000.00USD was granted, all i did was to follow the processing and be cooperative and today I am a proud business owner sharing the testimony of God-sent Lender. You can as well reach him through the Company WhatsApp +19292227023 Email drbenjaminfinance@gmail.com

    ReplyDelete
  50. “So I’m someone’s mom!” Welcoming our first child, Cecily , at 12:24 p.m. on Tuesday, July 14. We are absolutely head over heels in love with Cecily, and parenthood is already the most insane and beautiful thing in existence, It's made me excited to have a little spitfire of a daughter of my own. I remembered when i found out i was pregnant 3years ago and was about to walk away from the musical. But at eight weeks, i had a miscarriage. i was so unhappy, until i seek help spiritually from Priest Babaka the herbal practitioner, who helps and guide me to get pregnant again, even at the trying times few weeks in April when i battled symptoms of the coronavirus including "a cough that makes it feel like my head is splitting open from the inside out, but luckily, the baby was okay with the Priest help. i am happy to finally be a mother, couples out there that needs help, trying to conceive a baby, contact Priest Babaka on babaka.wolf@gmail.com or Facebook at priest.babaka , you will definitely have a baby to make you a parent. He handle Pregnancy related cases.




















    “So I’m someone’s mom!” Welcoming our first child, Cecily , at 12:24 p.m. on Tuesday, July 14. We are absolutely head over heels in love with Cecily, and parenthood is already the most insane and beautiful thing in existence, It's made me excited to have a little spitfire of a daughter of my own. I remembered when i found out i was pregnant 3years ago and was about to walk away from the musical. But at eight weeks, i had a miscarriage. i was so unhappy, until i seek help spiritually from Priest Babaka the herbal practitioner, who helps and guide me to get pregnant again, even at the trying times few weeks in April when i battled symptoms of the coronavirus including "a cough that makes it feel like my head is splitting open from the inside out, but luckily, the baby was okay with the Priest help. i am happy to finally be a mother, couples out there that needs help, trying to conceive a baby, contact Priest Babaka on babaka.wolf@gmail.com or Facebook at priest.babaka , you will definitely have a baby to make you a parent. He handle Pregnancy related cases.

    ReplyDelete