How can we have formulae appear in the text and a graph of the same data set appear in same discover.

- Senior Director of Product
- Ian_Macdonald
- 10 mths ago
- Reported - view
Hi Chaitali,

I'm not clear on what you mean. Can you show an annotated example?

Thanks,

Ian
- Associate Director
- Chaitali_Bhavik_Sanghavi
- 10 mths ago
- Reported - view
I have an sql output from a db and stored to in memory DB.Now i need to have a count of that query and also a numeric display of row count.Should that be 2 discovers covered in one presentation
- Associate Director
  
  Chaitali_Bhavik_Sanghavi
  
  10 mths ago
  
  Reported - view
  I found a simple way where I held count of the result set in a variable and refered it in dynamic text , choose format number 0 in the presentation I created.
- Associate Director
- Chaitali_Bhavik_Sanghavi
- 10 mths ago
- Reported - view
Inorder to get numbers you can select in discover a gauge chart.

Inorder to avoid seeing lables in the formatting panel remove all setting for Gauge Label as per the requirement

Select that discover in your presentation.

Another option is to use a grid graph:

In your presentation chose dynamic text option ,select your discover having the count as grid and set below format to see just numbers.

Here the discover will be a grid having Y axis as total.
- Let me connect you
- Community_chris
- 10 mths ago
- Reported - view
Thanks for Sharing!