This content has been marked as final. Show 5 replies
In my project, there is a field with dates . I need to draw a graph using the last 14 days. Now I use a formula to build measurement : aggr (if (rank ([Date]) < 14 , [Date]), [Date]). This function works , but not quite as much as I would like. If you select multiple values in the filter Date, the graph is redrawn and it remains only the selected values . I want to show always exactly 14 values in this graph.
How can I fix my code?