Hi Andy, Only one calculation is fine to show the last 3 months (not only last 3, we can create based user selection by creating parameter.) 1 create parameters take as int type, instead of =1 ,you can mention the
Hey Andy, this was a really great tutorial (as are your others) - thanks! I do have a question I hope you could help me with on this issue. I'm close to completing a dashboard but I'm very stuck on trying to figure out how to get a previous quarter based on data filtered for a specific quarter (with other filters available, like Market, Business Unit and Year) I've tried PREVIOUS_VALUE, LOOKUP and a couple of date functions, but it nothing seems to be working properly. It seems like the trick is that I'm filtering values, so I can't access the built-in YoY Growth calculation that I could then tweak to Quarter. For my purpose, I'd like users to filter on the above variables, so that they could see Totals Units Sold (for example) for say, Quarter 3, Year 2023, US Market, Business Unit X, AND I'd like to show the QoQ Growth by accessing Quarter 2's Total Units Sold for all the same filters. Do you have any ideas on how to tackle it? Many thanks in advance!
I had to do the similar thing instead prior I needed the next month. I created a parameter and bring the difference of that parameter(current month). So of you select July, it will populate June, July and August.
Andy, this is exactly what I was asking for at your Watch Me Viz today. I'm going through all these videos now. Thanks again for making them so easy to understand. Now if you can figure out how to just do a brain dump of all your viz knowledge, it would be a bit faster. 🤓
Hello Andy, Thanks for the video. Your examples are really helpful. I need your help on drill down. If we drill down by general method all the members in the hierarchy gets drilled down. But I want to drill down only specific member to the next level in the hierarchy. Please help. Thanks in advance...
Andy Kriebel - Can you please help me modify your Date formulas to use the Last Month WITH DATA instead of just the last month? This would help me immeasurably. Thank you in advance!
Dear Andy Sir, if you can add how to use single filter to show the current month and Current Year Data till the selected current month in the dashboard r. Like if I select December of 2023 that will show the December Sales data in one viz and as well as January to December 23 data in another viz
Thanks for the explanation, I tried to implement it get previous day transaction but granularity is getting changed so couldn’t achieve that 😔 It will be helpful if you can advise me on this please
Hi Andy, Is it possible to create a LOB calculation to compare dates. For example, I want to compare sales data from 8/2/2018 vs 6/15/2018, 8/2/2018 vs 6/10/2018, 8/2/2018 to 6/01/2018, etc.
great Video Andy, thanks a lot. One question you might help with. Sometimes Tableau let's me customize the format of the date in my worksheet completely which is great. But in other worksheets this formatting is almost not possible. Any ideas why? Thanks
Great tutorial Andy. I'm still struggling to get how to construct calculations in Tableau. Are you familiar with R? If so, is it correct to assume that Tableau as R works with vectorized operations? Meaning that I can consider each variable (column) in my data as a vector and my Calcs evaluate each one of the members of the variable?
Hi @@vizwiz I've created a calculation to return it to value with CASE, but there is an error "Cannot mix aggregate and non-aggregate". is there any alternative way?
Andy, love your videos. Advice to make this sheet dynamic so that "Latest Month" is a selected Month from a filter, previous is -1 of that, prior is -2 of that? Looking to show the selected months metric and then create a %Change from the previous month metric. Having some trouble getting everything to work together. Thanks
Hi Marc, not sure this is what you need and maybe there are better ways to do it...I am NOOOOOO EXPERT...but it works for me: my scenario: My Actual Expenditure is of course fixed but I need to compare them against different months of Forecast which fluctuates every month...so I needed 12 months to compare (and a filter to do the comparison but only changing forecast keeping actuals as is)... 1st I created a Parameter called "MONTH FORECAST " where data type is Integer then list value where 1 is displayed as January , 2 as February, so on until 12 for December Then 12 calculated fields (I think there might be a better way to do this...perhaps 1 field with all 12 months but I am NO expert and it was a quick fix for me... it works fine though ... specially when I have to compare one month vs another...I also dont have issues with grand totals, etc... so for each calculated field I named each by the month it refers to...this one is named "Forecast January" for example: IF DATEDIFF('month', DATETRUNC('month', [Month]), {MIN (DATETRUNC('month', [Month]))})=0 THEN [Forecast] END changing = 0 to 1, 2, 3, etc...that will correspond to the sequence of the months .. then a final calculated field called "FORECAST" only - using case formula linking to the parameter and the other 12 calculated fields returning values from my forecast column: CASE [MONTH FORECAST] WHEN 1 THEN SUM([Forecast January]) WHEN 2 THEN SUM([Forecast February]) WHEN 3 THEN SUM([Forecast March]) WHEN 4 THEN SUM([Forecast April]) WHEN 5 THEN SUM([Forecast May]) WHEN 6 THEN SUM([Forecast June]) WHEN 7 THEN SUM([Forecast July]) WHEN 8 THEN SUM([Forecast August]) WHEN 9 THEN SUM([Forecast September]) WHEN 10 THEN SUM([Forecast October]) WHEN 11 THEN SUM([Forecast November]) WHEN 12 THEN SUM([Forecast December ]) END then grab the last calculated field and drop into column field along with my actuals...then I show parameter to filter the forecast and start building my graphs.... I hope experts dont see this...as I mentioned I am pretty sure there are BETTER ways but until I find that better way... this works good :) hope it helps you!
That aren't LODs, I was expecting the use of FIXED, INCLUDE or EXCLUDE. Because a have to filter the view for an especific month, but, I need to show de MTD, and, If I filter the view the calculation of the MTD gets wrong
Hi Andy, Thanks for the video... Is that possible to view the N months by selecting year... i.e. If I select month June and Year 2020, then I want to view N months from that date... Can you please help me on this...
You can create a Boolean filter that only shows dates before the date selected. Then add that filter to context and the rest will work with the calcs I’ve shown.
Hi Andy I am from India here our financial year starts from April so when ever i apply your Calculations the date resets to January month kindly tell some tricks to do it
Here I have Students Data, I need show How many students Join selected month and prior month. How we can create chart that by using LOD Functions. How we can pass parameters on LOD functions. Why this is not working when counting IDs (COUNTD (Students ID) (due to agregation) and not sure how to fix it