Hello friends! I have some problems but think some Tableau guru can give an advice of quick help for me
I'm working on a project and stuck on the way how to present companies growth comparison by years. ( “growth” dashboard should implies a change in sales or customers).
I don't know how to show comparison by time period, so I want my visualization shows the following
1) Which companies within a specific TH level 1/2/3 and City/State grew the fastest between
(a) 2015 – 2018;
(b) 2016 – 2018
(c) 2017 - 2018 *
and between (d) 2015-2019 year to date;
(e) 2016 – 2019 year to date;
(f) 2017 – 2019 year to date and
(g) 2018 – 2019 year to date**
( I want to calculate sales for each of these companies for those years.)
* I need to do 2 separate calculations o For (a), (b) and (c), need to calculate absolute difference (example: 2018 values – 2015 values),
% change difference (example: 2018 value / 2015 value – 1),
and % compounded growth (example: [2018 value / 2015 value]^(1/3)-1.
** For (d), (e) and (f), need to calculate sales for each company from 1st week of January to last available date of data for 2019 [eg May 25, 2019], then do the same calculation for 1 st week of January to May 25, [Year].
Then need to calculate absolute difference (example: 2018 values – 2015 values), % change difference (example: 2018 value / 2015 value – 1), and % compounded growth (example: [2018 value / 2015 value]^(1/3)- 1
Please, I will appreciate any ideas on how to do this or advice for any part of this task.
Thank you, guys, for your time & help!*
Hello,
I admit, your data is quite complex and what you ask requires some time.
I believe I have done this part:
"* I need to do 2 separate calculations o For (a), (b) and (c), need to calculate absolute difference (example: 2018 values – 2015 values),
% change difference (example: 2018 value / 2015 value – 1),
and % compounded growth (example: [2018 value / 2015 value]^(1/3)-1."
The second part is more difficult, I did find the latest date in 2019 and get the same date a year earlier but havent been able to get it work so far.
I wanted to give you this before the weekend because I won't be able to work in it, hopefully this helps you and maybe someone else can continue the work.
