topic Re: Heatmap - set analysis date question in App Development

Heatmap - set analysis date question

Anonymous — Thu, 01 Oct 2015 18:04:48 GMT

I am trying to use a heatmap to show scores in different dimensions.

I am using an extension to have buttons set a variable to determine which line of business and which date to use (I don't want it affected by other selections). It seems to work for the Line of Business, but not for date. I currently get the most recent data whatever the date selection is. Any ideas?

The expression I am using is:

Sum({1<[LoB]={$(=vBrokerSurveyLoB)},[Date]={'=$(=vBrokerSurveyDate)'}>}[Score])

New to set analysis - so I suspect it is a syntax issue. It seems if I make the = for the Date into a <= it works okay and sums up the scores, but that is not what I want!

Many thanks in anticipation.

Chris

Re: Heatmap - set analysis date question

sunny_talwar — Thu, 01 Oct 2015 19:56:26 GMT

Is this a variable -> vBrokerSurveyDate

If it is, then how do you define this variable?

Re: Heatmap - set analysis date question

Anonymous — Thu, 01 Oct 2015 21:28:04 GMT

‌yes - it is a variable - set in the input variable extension I have added. So it uses for example 31/03/2014

Hope that helps.

Chris

Re: Heatmap - set analysis date question

sunny_talwar — Fri, 02 Oct 2015 00:22:59 GMT

How does a value like 31/03/2014 gets assigned to the variable???

and the goal is to calculate sum of square on a selected date??

Re: Heatmap - set analysis date question

jonathandienst — Fri, 02 Oct 2015 06:00:19 GMT

You might need this:

Sum({1<[LoB]={$(=vBrokerSurveyLoB)},[Date]={"=$(='vBrokerSurveyDate)'"}>}[Score])

or this

Sum({1<[LoB]={$(=vBrokerSurveyLoB)},[Date]={"=$(=Date('vBrokerSurveyDate)')"}>}[Score])

Re: Heatmap - set analysis date question

jonathandienst — Fri, 02 Oct 2015 06:01:18 GMT

Re: Heatmap - set analysis date question

ogster1974 — Fri, 02 Oct 2015 10:48:52 GMT

if you are using qsVariable be careful with form input vales especially dates as there is no validation checks so the user could enter anything.

Re: Heatmap - set analysis date question

Anonymous — Fri, 02 Oct 2015 10:57:23 GMT

It is set as part of the extension. I have currently set it as 31/12/2014. Not sure if I need to add a date function around it?

Yes - I want to get the heatmap to show the data from just that date.

Chris

Re: Heatmap - set analysis date question

Anonymous — Fri, 02 Oct 2015 10:58:21 GMT

I am using the drop down box - so I have sent the date to the variable within the object. Using 31/12/2014 or 31/03/2014 - I am presuming this is set as a date?

Cheers

Chris

Re: Heatmap - set analysis date question

Anonymous — Fri, 09 Oct 2015 11:21:16 GMT

Sorry for the delay - travelling with work!

Neether of these seem to work.

I have checked, and by inserting a "text" date 20140930 into the data, I can filter on that fine. So it is something to do with the way you format Dates in Set Analysis.

Obviously a " or ' somewhere in the wrong place but I can't figure it out!

Cheers

Chris