I have a dashboard which compares some KPI on current 4wks versus the last 4wks. Please see attached . i also have a straight line chart for trending the dashboard. I would want the straight line graph to show a comparison of the current 4wks versus the last 4wks on the same chart and differentiate the two trend lines. Is this possible? I am using weekYear and an expression for the charting which is as follows:
It is getting hard for me to think of this in a purely theoretical sense. Any chance you could post a sample document?
When you say you've added "these" to your calendar, were you referring to suggestion for adding the sequence numbers? If so, your task is fairly straightforward. Otherwise I'm not entirely sure what you're looking for.
What i was asking is what are the equivalent expressions for:
1. 8 weeks (Recent and Previous)
2. 12 weeks (Recent and Previous)
I am very new to ClikView
I added the two expressions for 4 weeks into my set variables (vRecentFourWeeks and vSetPreviousFourWeeks using the two examples you gave) and tried to use them but was getting errors. For example, the below expression gave me errors. Where am i going wrong?
I've had issues, myself using variables in this context that have search terms in the set analysis expression. Something about the double quotes seem to throw it off.
Have you tried using the code I supplied directly as an expression in your chart/report? I know that's not the approach your looking for and perhaps someone else following this thread can show us a way to do this, but I've yet to find it. Set variables are nice to use, but do have some limitations (double quotes).