Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

need help in adding a title of a chart

mohit9garg
8 - Asteroid

Hi,

 

I need help in adding a title of a chart. Then I need to save the output in a excel. Example is attached herewith.

 

@grossal 

9 REPLIES 9
deviseetharaman
11 - Bolide

Hi @mohit9garg 

 

Please check if the attached solution works for you.

 

Alteryx Calculation.png

 

rohan_santamaria
6 - Meteoroid

Hi  

 

The only problem with this is that it merges the cells which makes the format a bit difficult to view.
Is there anyway to prevent the merging of the cells?

 

Many thanks!

 

Regards,

Rohan

deviseetharaman
11 - Bolide

Hi @rohan_santamaria 

 

Could you please try adding a visual layout tool before Report Header and set the layout. Something as below:

 

Alteryx Calculation.png

rohan_santamaria
6 - Meteoroid

Many thanks!

mohit9garg
8 - Asteroid

@deviseetharaman still i can't see the header in excel output.

 

Refer attached output excel.

mohit9garg
8 - Asteroid

@DavidP  @grossal 

 

Please help me here.

deviseetharaman
11 - Bolide

Hi @mohit9garg ,

 

For excel output, please use "Report Text" tool instead of "Report Header".

Attached the workflow.

 

NB: Please mark as solution if you find this useful.

mohit9garg
8 - Asteroid

@deviseetharaman  thanks this worked

mohit9garg
8 - Asteroid

@deviseetharaman 

 

I have one more ask. I want to save the output in a excel's particular tab & cell. This option is available in OUTPUT tool but not in RENDER.

 

Please advise how can I do it.

 

Thanks

Labels