community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

display a calculation result directly on the canvas

Meteor

is there a way/tool to display the result(s) of a calculation, directly on the canvas ?

 

I have several points midway through the workflow at which I calculate a simple ratio

and would essentially like a "box" to sit right there and display the ratio when the workflow finishes

I would not normally ask this, but this particular workflow contains workflow variables and has to be run several times to achieve the proper ratio - changing the workflow variable each time

 

I am aware that I can look at the results in other ways (clicking an output, inserting a Browse etc)

I am also aware there are probably more advanced ways to model these sorts of things, just looking for a basic approach for now

 

thx

jb

Alteryx Certified Partner
Alteryx Certified Partner

Display results on canvas.png

 

@aoxomoxoa,

 

That was a fun question to solve for.  You do need to REFRESH at the end of the run, but here is how you can achieve your goal:

 

  1. plan for <path>\output.htm file that contains your desired results.
  2. configure an Explorer tool to read that file.
  3. setup data in your workflow to put it to a TABLE tool (as pretty as you want)
  4. RENDER the table to your htm file.

When you run, the data will be written to a file that will display as above.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Meteor

hi this solution is pretty interesting, thanks - it taught me a few new things

 

the additional tools to generate HTM are OK and work easily, no problem there

however, in terms of the request

the need to refresh the Explorer window every time - is pretty much a deal killer

and since I will wind up with multiple Explorer windows for multiple scenarios, this compounds the problem

 

I am looking for the values to be displayed directly on the canvas - without additional clicks/refresh at runtime - although extra tools and output files etc are fine at time of design

 

I am unable to provide the file as it contains proprietary information

 

open to other approaches .. may be a macro thing, not sure and not that advanced yet, I admit

Alteryx Certified Partner
Alteryx Certified Partner

You can run all of the data into a single render/html.  If you want to see the output and don't want to hit anything, you could write the data to the console and see it as messages at the end of the job.  I thought that this was a winning solution ;(

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Meteor

brilliant! - I used a Block Until Done, then a Message configured as a warning .. and a concatenated string with a constant, several ratios and a string result

 

I can now see the calculations as results realtime when the workflow completes .. rinse, repeat etc...

 

thanks very much 

Labels