-
1. Re: I wanted to compare current date with previous date data and show up and down arrow
Hey Farhan,
Can you please attach a workbook.
Thanks
Lovepreet
-
2. Re: I wanted to compare current date with previous date data and show up and down arrow
Hi Lovepreet ,
Please find the attached workbook for the same.
Regards,
Farhan Uddin Quidwai
-
3. Re: I wanted to compare current date with previous date data and show up and down arrow
Hi Farhan,
Hope attached twbx will give an Idea how to achieve this solution.
Regards,
Anupam
-
4. Re: I wanted to compare current date with previous date data and show up and down arrow
Hi Farhan,
Does the attached workbook answer your question?
I may not have chosen the correct measures and dimensions here, but you can adjust the calcs as you need. There is a reference line where the previous dates value is. You can select what dates to compare from and to using the date params on the right (only 2 dates in the data at the moment).
-
5. Re: I wanted to compare current date with previous date data and show up and down arrow
Hi Farhan,
Please find my approach as referenced below and stored in the attached.
Create a calc field.
Let me know if this helps.
~Tushar
-
6. Re: I wanted to compare current date with previous date data and show up and down arrow
Hey Tushar thanks for your help but i am trying to replicate the scenario like this :-
1)Arrow up if number of visitors is greater than previous day
2)Arrow down if number of visitors is lower than previous day
and it should display something like this:-
-
7. Re: I wanted to compare current date with previous date data and show up and down arrow
Hey Joe thanks for your help but i am trying to replicate the scenario like this :-
1)Arrow up if number of visitors is greater than previous day
2)Arrow down if number of visitors is lower than previous day
and it should display something like this:-
-
8. Re: I wanted to compare current date with previous date data and show up and down arrow
Hello Farhan,
Please find attached twbx file
Go to sheet name :[Visits/UV-Updated (2)] that i have created for Arrow symbols (refer calculation 1)
and added it to the editorial dashboard.
Check this on your live dat.
I have checked it for dummy data and it works. Hope this will help you.
Thank you.
