In this video we'll create a current month to previous month comparison using parameters and calculated fields. Get the underlying data file here: s3.amazonaws.com/nicolas.mese...
Is there any way we can do this without using parameter.. in my case I need to show the values comparison with PM/Year as well I need to have multi selector option.. any suggestions around it ?
So I'm assuming that ever since the really brilliant minds at Tableau removed the [Number Of Records] measurement the Create Calculated Field section doesn't work the same? I just keep getting errors about mixing aggregated and non-aggregated fields now with the [Extract]. UPDATE: got the formulas to work by switching to [Extract] and adding an ATTR conversion into the formula... now the final step doesn't work. I get all the Measure Values except for the three calculated fields which show up as zeroes and null in the percentage field. I genuinely don't understand why they have to update things into oblivion, I hope all Tableau employees get the squirts over christmas.
I want to calculate the WoW views of articles and want to see if they are increased/decreased. Can anybody help? For example for 4/1/21 the view is 23 and for 11/1/21 the view is 25 for the same article. Like that i have 10k articles week wise
Hi very easy to follow however Im getting expected type string found integer error when I use the formula below IF (MONTH([Date Occured])=[Month Parameter]) THEN [CustomerID] ELSE 0 END
Hi Nicolas, thanks for the help. I also want to calculate - total number of customers whose revenue has been contracted in comparison to previous month. How can I have aggregated number for all those customers who I had lost/contracted revenue ? Thanks
You really need to use table calculation, instead. First, if you want to see MoM by month, you can't do it with this method; secondly, what if you have MoM for a lot of measures, you have to create extra two calculated fields for each measures, it bring along a lot of extra work.
What a simple and clear steps explanation...thanks a lot
You saved my life!!! This is exactly what I'm looking for. Thanks for sharing!
Really appreciated it, I needed this too much, struggling for 3 days, you saved me...
Simply great, it's what exactly I am looking for, Thank a lot..
Excellent explanation!! Cleared my issue
DUDE YOU ARE A LIFE SAVER! THANK YOU THIS IS EXACTLY WHAT I LOOK FOR!!!
Keep it up bro. Finally found a very easy and effective solution for my problem. Thanks
Excellent one - Thank you Nic!!
Thank you somuch, You are life saver. It helped me a lot.
Awesome video, thanks a lot🙇♂️🙇♂️🙇♂️
THANK YOU SO MUCH! REALLY!😭🙏🏼
Nice and thanks for the share.
Thanks you... it really solve my problem
Is there any way we can do this without using parameter.. in my case I need to show the values comparison with PM/Year as well I need to have multi selector option.. any suggestions around it ?
Incredible video! Really usefull! What if you want to put current month, variance and a simbol like an arrow right next to each other? Thank you!
How did you do the percentage? It doesn't come out with the formula you put into it, and you have done a good job, thank you very much
So I'm assuming that ever since the really brilliant minds at Tableau removed the [Number Of Records] measurement the Create Calculated Field section doesn't work the same? I just keep getting errors about mixing aggregated and non-aggregated fields now with the [Extract].
UPDATE: got the formulas to work by switching to [Extract] and adding an ATTR conversion into the formula... now the final step doesn't work. I get all the Measure Values except for the three calculated fields which show up as zeroes and null in the percentage field. I genuinely don't understand why they have to update things into oblivion, I hope all Tableau employees get the squirts over christmas.
I started to follow then got stuck on the Number Incident Previous
I want to calculate the WoW views of articles and want to see if they are increased/decreased. Can anybody help? For example for 4/1/21 the view is 23 and for 11/1/21 the view is 25 for the same article. Like that i have 10k articles week wise
Hi very easy to follow however Im getting expected type string found integer error when I use the formula below
IF (MONTH([Date Occured])=[Month Parameter]) THEN [CustomerID] ELSE 0
END
If I want to display all month values in the parameters, how to do that? thanks
Thanks....
how do i use the hyper file in the description?
It used to be that Tableau can directly open hyper files and import the data. Doesn't that work any longer?
Hi Nicolas, thanks for the help. I also want to calculate - total number of customers whose revenue has been contracted in comparison to previous month. How can I have aggregated number for all those customers who I had lost/contracted revenue ? Thanks
You really need to use table calculation, instead. First, if you want to see MoM by month, you can't do it with this method; secondly, what if you have MoM for a lot of measures, you have to create extra two calculated fields for each measures, it bring along a lot of extra work.
Thanks for the feedback. Will look into your suggestion.