Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 3 KPIs that show, Unique Visitors, page views and Visits. I have data for each of these KPIs for the last 13 months but only want one months worth of data to show at any one time. I have a simple line graph plotting the changes M.o.M for these values, that I want to be able to click to select a month on the graph and the KPIs to the side then change to reflect that month. Does anyone know how to do this?
The current formula I have for the KPIs (as I want it to default to the latest month if no selection is made) are as follows:
(Sum(IF((Type='Unique Visitors' and [Month]='01/07/2016'),[Value])))
Is this even possible?
Thank you!
Try something like this:
Sum({<Type = {'Unique Visitors'}, Date = {"$(=Max(Date))"} [Value])
Hi Louisa,
yes, it should be possible.
What Sunny did, was to change your formula using what is called "Set Analysis".
I too think, that this should do the trick.
However I still have a question: Do you have full date values (including day) in the field called [Month]?
I ask, because if this would be the case, I find it most likely, that you propably might not have a [Date] field, as suggested for use as in Sunny's example and might have to adapt it a little bit by changing "Date" to "Month". But if you have a [Date] field, you will do just fine.