topic How to make KPIs change depending on clicks made on a graph? in App Development

How to make KPIs change depending on clicks made on a graph?

Fri, 19 Aug 2016 10:29:12 GMT

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!

Re: How to make KPIs change depending on clicks made on a graph?

sunny_talwar — Fri, 19 Aug 2016 12:27:13 GMT

Try something like this:

Sum({<Type = {'Unique Visitors'}, Date = {"$(=Max(Date))"} [Value])

Re: How to make KPIs change depending on clicks made on a graph?

katharinakostka — Fri, 19 Aug 2016 14:15:59 GMT

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.