Row level calculation and Two measurements in one Growth view
May I ask two questions?
- First is that is that possible to do row level calculation using formula in TS? Basically I want to show by month Sales YoY%(month this year vs last year) and MoM% (this month vs last month) in one table.
- If the first question is not doable in TS, I can show monthly YoY % and MoM% separately. I know I can use key word Growth to show month over month. I can do something like "growth of Sales by date monthly". But it seems like this only works for one measurement at one table. Can I show MoM% of two measurements in one table? For example, "growth of Sales and Margin by date monthly"?
Thank you very much in advance. Any help is appreciated.
Ma
-
Anybody can help?
-
Hi, you can do this through formulas. The following thread gives a number of ways to calculate different periods. Then you can calculate the growth based on these.
https://community.thoughtspot.com/t/805pj3/week-to-date-change
There a number of replies from Craig Haughan
-
Thank you so much for the help. And I also really appreciate Neil's help.
