-
1. Re: Current date and daily changes
Zhouyi ZhangJun 21, 2018 10:22 PM (in response to Haan Haan)
Hi, Haan
You need two parameters one control whether shows your dashboard as default of today or customized date to activate the customized date parameter.
ZZ
-
2. Re: Current date and daily changes
Haan Haan Jun 21, 2018 10:41 PM (in response to Zhouyi Zhang)Dear ZZ
What about the calculation field ?
How should i do it?
Thanks
-
3. Re: Current date and daily changes
Zhouyi ZhangJun 21, 2018 11:13 PM (in response to Haan Haan)
-
Book2_v10.2.twbx 1.2 MB
-
-
4. Re: Current date and daily changes
Haan Haan Jun 21, 2018 11:34 PM (in response to Zhouyi Zhang)Dear ZZ
Thank you very much!
-
5. Re: Current date and daily changes
Haan Haan Jun 21, 2018 11:42 PM (in response to Zhouyi Zhang)Dear ZZ
May I know if i want the % of daily differences of the sales, where the calculation field is something like that as below:
(TODAY-PREVIOUS DAY)/ PREVIOUS DAY
How should i achieve it?
-
6. Re: Current date and daily changes
Zhouyi ZhangJun 22, 2018 12:03 AM (in response to Haan Haan)
HI, Haan
Have a look at my updated workbook attached and let me know if any question.
ZZ
-
Book2_v10.2.twbx 1.1 MB
-
-
7. Re: Current date and daily changes
Haan Haan Jun 22, 2018 3:59 AM (in response to Zhouyi Zhang)Dear ZZ
Thanks a lot !
Allow me to state the steps out Could u please check is it correct?
1. Create 2 parameters
2. Create 3 Calculation Fields
I have tried on it...but looks like no reaction...and I dont know the variance and current date calculation field...
-
Book2.twbx 6.9 KB
-
-
8. Re: Current date and daily changes
Haan Haan Jun 22, 2018 1:20 AM (in response to Zhouyi Zhang)Dear ZZ
One more question...if i want to do only the default? (no customized date)
Means only show the data for today and the data for differences of the previous day.
Thanks
-
9. Re: Current date and daily changes
Zhouyi ZhangJun 22, 2018 7:03 AM (in response to Haan Haan)
1 of 1 people found this helpfulHi, Haan
Please see my comments below
If you don't need customized date, just comment out the lines in current Date calculation as shown below
ZZ
-
-
-
12. Re: Current date and daily changes
Zhouyi ZhangJun 28, 2018 7:08 PM (in response to Haan Haan)
Hi Haan
Yes, it can be a calculation.
To your question of missing day, it will be not easy to determine how many dates going backward. my suggestion will be filter the missing date in between.
ZZ
-
13. Re: Current date and daily changes
Haan Haan Jul 2, 2018 7:29 PM (in response to Zhouyi Zhang)Dear ZZ
Referring to the sales cal and variance calculation field....may i know how to amend it if wanted the null to become 0?
for the sales cal i am able to do it as below...but the variance i cant
ZN(lookup(sum(IF [Date] = [DateLbl] THEN [Sales] END),0))
May i know how to do it?