# Ask the Community **URL:** https://community.holistics.io/c/ask/16.md?page=4 [Latest](https://community.holistics.io/latest.md) · [Categories](https://community.holistics.io/categories.md) · [Tags](https://community.holistics.io/tags.md) **Page:** 5 --- ## [Updating database information in a reverse-tunnel datasource](https://community.holistics.io/t/updating-database-information-in-a-reverse-tunnel-datasource/1840)
**Author:** [@Chip](https://community.holistics.io/u/Chip)\ **Replies:** 4\ **Last updated:** [February 29, 2024, 12:38am UTC](https://community.holistics.io/t/updating-database-information-in-a-reverse-tunnel-datasource/1840 "2024-02-29T00:38:36Z")
I read in another post that it is not possible to update database Host/Port information via the API for a datasource that is using a reverse tunnel (it is also not updatable via the UI). It seems that I am unable to upd… --- ## [Use filters when we share the dashboard](https://community.holistics.io/t/use-filters-when-we-share-the-dashboard/1834)
**Author:** [@Hamza\_rashed](https://community.holistics.io/u/Hamza_rashed)\ **Replies:** 1\ **Last updated:** [February 26, 2024, 3:14am UTC](https://community.holistics.io/t/use-filters-when-we-share-the-dashboard/1834 "2024-02-26T03:14:43Z")
Hi Team, I have shared some dashboards using Shareable Links. Because I need all users have access to these dashbaords even if they don’t have a Holistics account. The dashboard working fine but they are facing an issu… --- ## [List of sparklines - sort of like a metric sheet?](https://community.holistics.io/t/list-of-sparklines-sort-of-like-a-metric-sheet/1807)
**Author:** [@Matt\_Stone](https://community.holistics.io/u/Matt_Stone)\ **Replies:** 2\ **Last updated:** [February 22, 2024, 9:31pm UTC](https://community.holistics.io/t/list-of-sparklines-sort-of-like-a-metric-sheet/1807 "2024-02-22T21:31:26Z")
I’m trying to replicate a visualization I made in Google Sheets using the sparkling formula. It’s similar to the metrics sheet in Holistics, but not using the date slice approaches. Here’s a snippet: There are actu… --- ## [Change the color of the bars in Chart](https://community.holistics.io/t/change-the-color-of-the-bars-in-chart/1812)
**Author:** [@Hamza\_rashed](https://community.holistics.io/u/Hamza_rashed)\ **Replies:** 1\ **Last updated:** [February 15, 2024, 2:52am UTC](https://community.holistics.io/t/change-the-color-of-the-bars-in-chart/1812 "2024-02-15T02:52:54Z")
Hi Team, I have created a chart as the below .. I need to make each bar has a different background color .. I know they have the same column so because of that they listed with the same color .. But I need a way to chan… --- ## [Webhooks Integration](https://community.holistics.io/t/webhooks-integration/1803)
**Author:** [@Hamza\_rashed](https://community.holistics.io/u/Hamza_rashed)\ **Replies:** 2\ **Last updated:** [February 9, 2024, 5:30am UTC](https://community.holistics.io/t/webhooks-integration/1803 "2024-02-09T05:30:23Z")
Hi Team, Can you please list the steps that I need to follow to create a successfuly webhooks integration with Holistics. Because for now I see it as a Coming Soon .. Also If you don’t have it now .. Please tell me whe… --- ## [Get data from API](https://community.holistics.io/t/get-data-from-api/1801)
**Author:** [@Hamza\_rashed](https://community.holistics.io/u/Hamza_rashed)\ **Replies:** 1\ **Last updated:** [February 7, 2024, 10:50am UTC](https://community.holistics.io/t/get-data-from-api/1801 "2024-02-07T10:50:04Z")
Hi Team, Can I retrieve data from another website’s API using Holistics? Example : \`\`\` https://sportsop-soccer-sports-open-data-v1.p.rapidapi.com/v1/leagues/{league\_slug}/seasons/{season\_slug}/rounds This API link I … --- ## [Reverse ERD model](https://community.holistics.io/t/reverse-erd-model/1797)
**Author:** [@doniuppa](https://community.holistics.io/u/doniuppa)\ **Replies:** 1\ **Last updated:** [February 7, 2024, 3:26am UTC](https://community.holistics.io/t/reverse-erd-model/1797 "2024-02-07T03:26:55Z")
The documentation suggests the capability to reverse engineer a model but it does not say how to do it. How is this done? Did I miss the directions? " In some databases where foreign key constraints are already imple… --- ## [Grid Resizing - How to](https://community.holistics.io/t/grid-resizing-how-to/1786)
**Author:** [@jsaaiman](https://community.holistics.io/u/jsaaiman)\ **Replies:** 3\ **Last updated:** [February 1, 2024, 8:33am UTC](https://community.holistics.io/t/grid-resizing-how-to/1786 "2024-02-01T08:33:21Z")
Is there a way to resize the grid in dashboard structure? The grid is large enough that it creates unnecessary white space between reports on a dash but one step smaller cuts off the total at the bottom of a report. --- ## [What if I decided to stop using Holistics in the future?](https://community.holistics.io/t/what-if-i-decided-to-stop-using-holistics-in-the-future/1788)
**Author:** [@Hamza\_rashed](https://community.holistics.io/u/Hamza_rashed)\ **Replies:** 1\ **Last updated:** [January 31, 2024, 4:36am UTC](https://community.holistics.io/t/what-if-i-decided-to-stop-using-holistics-in-the-future/1788 "2024-01-31T04:36:44Z")
Hi Team, If we would like in the future to stop using Holistics … I just need to know if there is minimum amount of days if we decide to not use Holistics anymore. so do we need to give 60 days notice? Thanks --- ## [Multiple users collaborating on the same dashboard / transfer of dashboard ownership](https://community.holistics.io/t/multiple-users-collaborating-on-the-same-dashboard-transfer-of-dashboard-ownership/951)
**Author:** [@Guido\_Stark](https://community.holistics.io/u/Guido_Stark)\ **Replies:** 6\ **Last updated:** [January 19, 2024, 3:28am UTC](https://community.holistics.io/t/multiple-users-collaborating-on-the-same-dashboard-transfer-of-dashboard-ownership/951 "2024-01-19T03:28:48Z")
Hi team, Looking for some advice on best practice when it comes to users collaborating on a dashboard together. We have a set up where we have 2 Admins, and all other users are Explorers. We have no users with the An… --- ## [Change default date drill settings](https://community.holistics.io/t/change-default-date-drill-settings/1088)
**Author:** [@Abdel](https://community.holistics.io/u/Abdel)\ **Replies:** 6\ **Last updated:** [December 29, 2023, 9:10am UTC](https://community.holistics.io/t/change-default-date-drill-settings/1088 "2023-12-29T09:10:10Z")
Hi, Is it possible to set the date drill setting of a dashboard by defaul to to week for example? --- ## [GET data\_model ID (API)](https://community.holistics.io/t/get-data-model-id-api/1767)
**Author:** [@Grant\_Orchard](https://community.holistics.io/u/Grant_Orchard)\ **Replies:** 3\ **Last updated:** [December 25, 2023, 10:58am UTC](https://community.holistics.io/t/get-data-model-id-api/1767 "2023-12-25T10:58:46Z")
Hi Team - I need extract some metadata and really struggling with the Holisitics documentation. I am using Postman to test the api’s but when I trying to access data model id i hit a wall. My end goal is have a list of … --- ## [Pipe delimited Files](https://community.holistics.io/t/pipe-delimited-files/1747)
**Author:** [@Hamza\_rashed](https://community.holistics.io/u/Hamza_rashed)\ **Replies:** 6\ **Last updated:** [December 21, 2023, 3:10pm UTC](https://community.holistics.io/t/pipe-delimited-files/1747 "2023-12-21T15:10:26Z")
Hi Great Team, Can we send the files in pipe delimited via Holistics ? If not please give me the closest way to do it --- ## [What's with the make it snow?](https://community.holistics.io/t/whats-with-the-make-it-snow/1766)
**Author:** [@sm\_mk](https://community.holistics.io/u/sm_mk)\ **Replies:** 1\ **Last updated:** [December 20, 2023, 4:59am UTC](https://community.holistics.io/t/whats-with-the-make-it-snow/1766 "2023-12-20T04:59:53Z")
What’s with the make it snow logo in the corner and do we have the option to disable? I’m guessing our users will start pinging us so i want to get ahead of it. --- ## [Tips on handling multiple join conditions (composite key) between 2 data models?](https://community.holistics.io/t/tips-on-handling-multiple-join-conditions-composite-key-between-2-data-models/1419)
**Author:** [@jingyu](https://community.holistics.io/u/jingyu)\ **Replies:** 4\ **Last updated:** [December 20, 2023, 3:51am UTC](https://community.holistics.io/t/tips-on-handling-multiple-join-conditions-composite-key-between-2-data-models/1419 "2023-12-20T03:51:01Z")
I noticed that only 1 join condition can be defined when creating a relationship between 2 data models in Holistics: We have 2 models that should be joined on 2 columns: Month User ID Currently, we create surrogat… --- ## [Unable to relate two dimension models to two fact models in dataset](https://community.holistics.io/t/unable-to-relate-two-dimension-models-to-two-fact-models-in-dataset/1405)
**Author:** [@shahidt](https://community.holistics.io/u/shahidt)\ **Replies:** 8\ **Last updated:** [December 19, 2023, 8:59am UTC](https://community.holistics.io/t/unable-to-relate-two-dimension-models-to-two-fact-models-in-dataset/1405 "2023-12-19T08:59:58Z")
I come from a Star Schema background and am evaluating Holistics. I have two dimension tables - offers and campaigns, and two fact tables - viewings and viewings users. I created data models and related them as shown bel… --- ## [Best practices for optimizing object count](https://community.holistics.io/t/best-practices-for-optimizing-object-count/1765)
**Author:** [@Pratik\_Mukherjee1](https://community.holistics.io/u/Pratik_Mukherjee1)\ **Replies:** 1\ **Last updated:** [December 18, 2023, 8:30am UTC](https://community.holistics.io/t/best-practices-for-optimizing-object-count/1765 "2023-12-18T08:30:55Z")
Please share some best practices that can be followed to limit the object count on holistics. --- ## [Data Alert with a KPI Metric](https://community.holistics.io/t/data-alert-with-a-kpi-metric/1754)
**Author:** [@Conner\_Ellsworth](https://community.holistics.io/u/Conner_Ellsworth)\ **Replies:** 1\ **Last updated:** [December 7, 2023, 2:46am UTC](https://community.holistics.io/t/data-alert-with-a-kpi-metric/1754 "2023-12-07T02:46:16Z")
Hello! I have a KPI metric and want to create a data alert for said metric. I want to be alerted one time when the KPI metric has hit a certain number. Is there a way to bypass the standard alert options (alert every te… --- ## [Bulk editing users](https://community.holistics.io/t/bulk-editing-users/1013)
**Author:** [@sm\_mk](https://community.holistics.io/u/sm_mk)\ **Replies:** 9\ **Last updated:** [November 30, 2023, 3:17am UTC](https://community.holistics.io/t/bulk-editing-users/1013 "2023-11-30T03:17:32Z")
I’ve got a big surge of users coming and beyond setting them up one by one I also have to set attributes and add to groups. I saw the line “Allow Admins to invite multiple users” which I’m guessing will help at some poi… --- ## [Adding % of Total column](https://community.holistics.io/t/adding-of-total-column/1740)
**Author:** [@Grant\_Orchard](https://community.holistics.io/u/Grant_Orchard)\ **Replies:** 3\ **Last updated:** [November 27, 2023, 8:00am UTC](https://community.holistics.io/t/adding-of-total-column/1740 "2023-11-27T08:00:40Z")
hi, Is it possible to create a column with the % of overall total. eg. showcase ‘city’ and ‘active users’ and then have a column with the % overall total? --- ## [Connection to Database in private network like AWS RDS](https://community.holistics.io/t/connection-to-database-in-private-network-like-aws-rds/1735)
**Author:** [@Thien\_Lam](https://community.holistics.io/u/Thien_Lam)\ **Replies:** 2\ **Last updated:** [November 20, 2023, 9:30am UTC](https://community.holistics.io/t/connection-to-database-in-private-network-like-aws-rds/1735 "2023-11-20T09:30:06Z")
Hi. I’m have an PostgresQL in AWS RDS. I don’t know if, with my RDS in a private network, there is a way for me to connect to that RDS. --- ## [Change underlying table of a model](https://community.holistics.io/t/change-underlying-table-of-a-model/1719)
**Author:** [@raulcruzv](https://community.holistics.io/u/raulcruzv)\ **Replies:** 4\ **Last updated:** [November 8, 2023, 3:28am UTC](https://community.holistics.io/t/change-underlying-table-of-a-model/1719 "2023-11-08T03:28:29Z")
Is it possible to modify the underlying table of a model? We have an adjusted table that has the same metadata as the original one. We want to point the model to this new table. --- ## [Setting up persistence model in modeling 4.0](https://community.holistics.io/t/setting-up-persistence-model-in-modeling-4-0/1721)
**Author:** [@Matt\_Stone](https://community.holistics.io/u/Matt_Stone)\ **Replies:** 7\ **Last updated:** [November 3, 2023, 7:34am UTC](https://community.holistics.io/t/setting-up-persistence-model-in-modeling-4-0/1721 "2023-11-03T07:34:01Z")
I’m trying to setup a persistent model for the first time in a postgres db integration. I have been following instructions from these references: Query Model | Holistics Docs (4.0) Model Storage Settings | Holistics D… --- ## [Pass the same filter to many models](https://community.holistics.io/t/pass-the-same-filter-to-many-models/1722)
**Author:** [@Hamza\_rashed](https://community.holistics.io/u/Hamza_rashed)\ **Replies:** 1\ **Last updated:** [November 2, 2023, 9:25am UTC](https://community.holistics.io/t/pass-the-same-filter-to-many-models/1722 "2023-11-02T09:25:26Z")
I have created a dataset using multible models .. When I tried to add a filter to this report I can select only one model ?? .. I need to pass the same filter to many models Example :: In the example above I have cr… --- ## [Shareable Links and Public Role](https://community.holistics.io/t/shareable-links-and-public-role/1715)
**Author:** [@raulcruzv](https://community.holistics.io/u/raulcruzv)\ **Replies:** 2\ **Last updated:** [October 25, 2023, 5:09am UTC](https://community.holistics.io/t/shareable-links-and-public-role/1715 "2023-10-25T05:09:10Z")
Is there a way to associate Shareable Links with Public users? We have a Dashboard with 50+ shareable links. We are able to see the dashboard activity in the “Usage Monitoring Dashboard” but we have not figured out a way… --- ## [Multiple Y axis - hide axis](https://community.holistics.io/t/multiple-y-axis-hide-axis/1714)
**Author:** [@Beatriz](https://community.holistics.io/u/Beatriz)\ **Replies:** 2\ **Last updated:** [October 19, 2023, 10:05am UTC](https://community.holistics.io/t/multiple-y-axis-hide-axis/1714 "2023-10-19T10:05:13Z")
Hi, Is there a way to hide some Y axis when having 3+ axis? See example below. Thanks, Beatriz --- ## [Email Schedules Using API](https://community.holistics.io/t/email-schedules-using-api/1594)
**Author:** [@Hamza\_rashed](https://community.holistics.io/u/Hamza_rashed)\ **Replies:** 10\ **Last updated:** [October 12, 2023, 3:08am UTC](https://community.holistics.io/t/email-schedules-using-api/1594 "2023-10-12T03:08:10Z")
I tried to create a Schedules using Email .. And I need to export the dashboard in one excel file and with Multiple Sheets .. I mean I need to select the below option using API .. So I tried to wrote “excel\_dashboard… --- ## [Create multiple pivots table in one report](https://community.holistics.io/t/create-multiple-pivots-table-in-one-report/1705)
**Author:** [@Hamza\_rashed](https://community.holistics.io/u/Hamza_rashed)\ **Replies:** 1\ **Last updated:** [October 11, 2023, 9:14am UTC](https://community.holistics.io/t/create-multiple-pivots-table-in-one-report/1705 "2023-10-11T09:14:52Z")
Can we create multiple pivots table in one report --- ## [Reports fed by a specific model or dataset](https://community.holistics.io/t/reports-fed-by-a-specific-model-or-dataset/1698)
**Author:** [@Beatriz](https://community.holistics.io/u/Beatriz)\ **Replies:** 1\ **Last updated:** [October 2, 2023, 4:35am UTC](https://community.holistics.io/t/reports-fed-by-a-specific-model-or-dataset/1698 "2023-10-02T04:35:06Z")
Is there an easy way to check which reports are fed by a specific model or dataset? I need to substantially modify one of my models in dbt, and I’d like to know which reports will be impacted by this change. Thank you, … --- ## [Top N filter (parent or child)](https://community.holistics.io/t/top-n-filter-parent-or-child/1686)
**Author:** [@Grant\_Orchard](https://community.holistics.io/u/Grant_Orchard)\ **Replies:** 4\ **Last updated:** [September 28, 2023, 2:27am UTC](https://community.holistics.io/t/top-n-filter-parent-or-child/1686 "2023-09-28T02:27:13Z")
Hi team ! looking for some assistance please. I am trying to add a filter to a dashboard. Top 25 cities, by total\_active\_users. The aim is to have all my tables in the dashboard show the same top 25 cities, but unfortuna… [Previous page](https://community.holistics.io/c/ask/16.md?page=3) [Next page](https://community.holistics.io/c/ask/16.md?page=5)