on 08-01-2016 6:31 PM
Example: You do some filter of especific year(2016 for example) and I need that calculated field show the another year(2015 for example) information out of that filter you did.
Hi Jezer,
When you filter the year you would not able to get the result you desire, as you will be limiting the data to only 2016. Thus the 2015 data will not be available to visualize.
A similar scenario which I faced was to display a rolling 24 month chart. This means that if I select July 2016, I should be able to see data from Aug 2014-July 2016. This can be developed as formulas in Lumira or the best would be to create queries in the backend system.
I can set the month/quarter/year selection with Refresh on Prompts as shown below,
Then we can make the corresponding date selection as Variables,
This would give me a dynamic date range based on my selection.
Please let me know if there are any questions or comments.
Thank you,
Varun Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.