Selecting Metric for Last Date Specified and Not summing the numbers
I am currently bringing in Data for the increments over time and looking to have a metric that just takes the very last date specified in the date range.
An example would be Facebook Page likes, we bring in the data by month by day. For a monthly report, we want to just take the last number that has the total likes as their data is exported like
Day Total Likes
and so on.
So I would want 37 to be displayed and not a sum of all the numbers or if I select a date range of 1-2 I want the last date which is 2 data to display which would be 29 and not 54 when it sums it up.
Max could work but there might be times where the number decreases.
I think maybe a customer case statement for last days of every month might work but would prefer to have an option for just the last date selected. If there is an option for this it would be extremely helpful for multiple projects