2 Replies Latest reply: May 14, 2014 5:15 AM by Kasia Cwik RSS

    Expression calculation for (only) last month from selected months?



      I have a table with an expression that calculated Average Survey Answers over a selected period of time (months). I have to add another expression to do the same calculation - Average Survey Answers, but for the last month from the selected months. So for example if I select Apr, May, Jun and July I want my second expression to display the results for July only, as July is the last month is my selection. My expression is based on a variable called. Any ideas? I cannot post the dashboard as it's client work...