http://forums.visokio.com/discussions/tagged/formula_result/feed.rss Mon, 30 Oct 17 15:47:31 -0400 Tagged with formula_result - Visokio Forums en-CA http://forums.visokio.com/discussion/3130/formula-field-omniscope-freezes-with-subset_uniquecount Mon, 23 May 2016 10:50:30 -0400 daniel 3130@/discussions
All I am doing is trying to create a rate field of:

Subset_sum([Dementia Register])/Subset_uniquecount([Practice Code])



Version 2.9 b1823 on a Win 10 desktop and also tested on a win 10 laptop. Problem persists in both.

]]> http://forums.visokio.com/discussion/3052/dynamic-title-text-to-reflect-the-selection Mon, 07 Dec 2015 09:00:22 -0500 Phillipa 3052@/discussions
I am working on dashboards that go to a client and would like to add a dynamic Title that reflects the chosen stack.

The only way I know to get dynamic text is to use the content view and a formula.
However, I cannot find an option that will allow me to show which stack is showing. Specifically I want to give the customer the option of choosing between 2 stacks and the title to the chart should change according to which stack is chosen ( in this case the performance indicator ECOG & Karnofsky Index).

Is there a way to do this?

Thanks for any help
Phillipa]]> http://forums.visokio.com/discussion/2462/formulae-preserving-selected-formulas-downstreams Tue, 04 Feb 2014 07:12:24 -0500 Master_Chief 2462@/discussions
Is there anyway to only preserve certain formulas downstream, I want to perform a formula on a aggregated field which is itself another formula. I realise this can be done through using two Field Organiser blocks, however I was hoping to keep things cleaner.

Thanks,

Chris]]> http://forums.visokio.com/discussion/2294/barline-view-formula-for-month-over-month Wed, 21 Aug 2013 12:50:15 -0400 Milton 2294@/discussions
We have tried with "subset_sum" and "subset_mean" but it is not possible to do the calculation. Can you please help me with this?


IF(SUBSET_SUM([Month])="Febrero",SUBSET_SUM([Likes]))/IF(SUBSET_SINGLETON([Month])="Enero",SUBSET_SUM([Likes]))-1

IF(SUBSET_SUM([Likes])>0,(SUBSET_SUM([Likes],SUBSET([Mes],2))-SUBSET_SUM([Likes],SUBSET([Mes],1)))/SUBSET_SUM([Likes],SUBSET([Mes],1)))]]> http://forums.visokio.com/discussion/2215/outputs-exporting-pdf-from-datamanager-block-formulae-resultss Thu, 27 Jun 2013 04:21:21 -0400 benjamin 2215@/discussions
In Omniscope, on the tabs the graphs are correct. Also, if from Omniscope Command menu I go File > Export to PDF, the exported PDF is the same as the Omniscope tabs (which is correct).

However, if I go to DataManager and add an Output to PDF block to the data flow after the blue "Omniscope" block, the PDF result is incorrect and it appears like the results are being summed rather than using the "Formulae" result.

Version 2.8 build 978 ....Please could you advise

Thanks, Ben
]]> http://forums.visokio.com/discussion/1832/aggregation-formula-result-option-for-viewss Sun, 14 Oct 2012 23:46:58 -0400 shaji_o 1832@/discussions
However I can't see this option for graphs. Is this option available for a line/bar graph? Or any other graph for that matter?]]> http://forums.visokio.com/discussion/690/dial-view-showing-formula-results Fri, 25 Mar 2011 11:56:46 -0400 jrudman 690@/discussions http://forums.visokio.com/discussion/1603/formula-result-in-barline-view Fri, 15 Jun 2012 09:27:40 -0400 alec_webliquid 1603@/discussions
I can't see this as an option - am I missing something or has it not been implemented? My field is a formula field and treated as such (formula result) when aggregating within the view, however when selecting in 'Measures', formula result is not given as an option. The attached screenshot illustrates this.

If it has not been implemented, can I please request it?

Cheers]]>