Wiki source code of Mesure cumulée à l’année (YTD)
Last modified by Aurelie Bertrand on 2020/07/29 16:38
Show last authors
author | version | line-number | content |
---|---|---|---|
1 | ~{~{toc/}} | ||
2 | |||
3 | ~-~-~-~- | ||
4 | |||
5 | ~= Create a new calculated measure = | ||
6 | |||
7 | ~* Add the measure on which you want to apply the year to date | ||
8 | ~* Click on the measure, add a date dimension | ||
9 | ~* Add a filter and use a function predefined, select “Year (Selection)” | ||
10 | This measure will do the cumulation from the beginning of the year to the date chosen in the date selector. This means that a date selector must be present in the dashboard with hierarchy ~(% style="color:#16a085" %)~*~*Year Month~*~* | ||
11 | |||
12 | ~= Graphic illustration = | ||
13 | |||
14 | ~[~[image~:https:~/~/lh5.googleusercontent.com/f6~_~_6vTsSEGB3W_wS1jWDuTCHiyKhXJl930RbQCIhcHDH-iZ6UtHdUmiwc3SHmscc8Y3TTIzyDsrajCueQwcqoHOByFRaRslpHk1xNzrRwuw5rrFgtq237FQN_VJFoSAEcik_19VCLM||height="457" width="847"]] |