# Generate custom reports for each customer in Kibana Canvas

**URL:** https://discuss.elastic.co/t/generate-custom-reports-for-each-customer-in-kibana-canvas/270148
**Category:** Kibana
**Tags:** canvas
**Created:** [April 14, 2021, 8:39pm UTC](https://discuss.elastic.co/t/generate-custom-reports-for-each-customer-in-kibana-canvas/270148 "2021-04-14T20:39:53Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Eivind\_Vinsand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eivind_vinsand/32/86648_2.png) [@Eivind\_Vinsand](https://discuss.elastic.co/u/Eivind_Vinsand)
#### Post date: [April 14, 2021, 8:39pm UTC](https://discuss.elastic.co/t/generate-custom-reports-for-each-customer-in-kibana-canvas/270148/1 "2021-04-14T20:39:53Z")

</div>

Hi!

I have made a report in Kibana Canvas where I have calculated four metrics. Now I want to generate 100 versions of this report, one for each customer. This means I have to recalculate the metrics for each customer in my dataset. Is there a way I can set up Kibana to generate this report 100 times for each customer every month automatically? How would I refer to customer X in column Y and create this loop?

I would be really grateful if someone could help me with this issue.

- Eivind Vinsand

---

<div class="post-metadata">

### Author: ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)
#### Post date: [April 15, 2021, 4:27am UTC](https://discuss.elastic.co/t/generate-custom-reports-for-each-customer-in-kibana-canvas/270148/2 "2021-04-15T04:27:07Z")

</div>

You need to get the customer name from the URL. Therefore Canvas offers Urlparams

> **[Canvas function reference | Kibana Guide \[7.12\] | Elastic](https://www.elastic.co/guide/en/kibana/current/canvas-function-reference.html#urlparam_fn)**

The urlparam needs to be set as filter in your query. Thatway you have a different view per customer.

To schedule reporting is usually done with Watcher. But you would need to create one Watcher job per customer. I think a python script cronjob that triggers the report Generation would be easier in this case.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 13, 2021, 4:27am UTC](https://discuss.elastic.co/t/generate-custom-reports-for-each-customer-in-kibana-canvas/270148/3 "2021-05-13T04:27:59Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.