Hey ramansingh89 ,
Did you try to use the PREV-function?
It is not possible to insert all 8 of your requests in 1 widget (unless you use the free Advanced Indicator Card plugin from Ravid_PaldiTeam ). However it is possible to do this in multiple indicators
More on the prev-function can be found here: https://docs.sisense.com/main/SisenseLinux/dashboard-functions-reference.htm?tocpath=Dashboards%7CFormulas%20and%20Functions%7C_____12
I dont know if it is exactly what you looking for, however I managed to get something similar up and running. In the screenshot below we see
- the first column is a sum based on the a date filter that the user can use (this is set to this week)
- the second column is a sum based on a static filter i set to validate the result with the first column
- the third column is a sum based on the a date filter that the user can use and calculates the week prior
- the fourth column is a sum based on a static filter i set to validate the results of the third column
I uses the prev-function and a hardcoded date-range in the other columns to validate the results and they are the same.
Hamza
