1. So because my company is looking into transitio...
# gooddata-cn
k
1. So because my company is looking into transitioning visualizations from Tableau to GoodData, I was wondering if GoodData has a feature similar to Tableau's Parameters. We have a table that categorizes various assets by credit rating. In Tableau, you could make a dropdown that allows you to select what credit rating system you want to use which changes the set of credit ratings the assets are categorized by. Is there an equivalent in GoodData? 2. Tableau also has what is called Calculated Columns. I understand that in GoodData, you can do similar things with a metric but not an attribute. Is there a way to have an attribute derived from existing attributes without turning the attribute into a metric?
m
Hi Kevin, thank you for your questions. While we're not familiar with Tableau's specific features, it is challenging to fully understand the exact behaviour you're looking to replicate in our platform. However, we can explain how GoodData handles the possible similar needs. 1. If you're looking for a way to let users dynamically select options from a dropdown (like different credit rating systems) to change what data appears or how it's categorized, our primary tool is Dashboard Filters. You can create filters based on your data attributes, and these will allow users to interact with your dashboard and update all connected insights based on their selection. Also, we have 'Drilling', which allows users to click on a part of a visualization to navigate to a more detailed insight, another dashboard, or even an external URL, Please refer to our documentation for more details on Drilling: https://www.gooddata.com/docs/cloud/create-dashboards/drilling-in-dashboards/ 2. When it comes to creating new attributes from your existing data (like combining 'First Name' and 'Last Name' into 'Full Name'), I am afraid it can not be done directly in the Analytical designer as all the MAQL output are metrics -> numerical values, no string. To help us perfectly understand what you'd like to achieve for derived attributes, could you provide a simple example? We hope this clarifies how GoodData can meet these needs. Please feel free to ask further questions!
k
Thanks for the response! In response to #1... So my understanding is that Dashboard Filters does so on an aggregate level. For example... if I filter out "Fine Dining", I filter out all rows containing "Fine Dining". What I want more so is being able to create a dropdown or some sort of form control that is able to change what rows or columns I use for a GoodData visualization without having to manually edit the metrics, attributes, or filters for the rows or columns. https://help.tableau.com/current/pro/desktop/en-us/changing-views-using-parameters.htm In response to #2... For example... if you had like a column containing license plates or something and you want to create an attribute column that takes each of these license plates and maps them to a state. (essentially, to be able to map values to values that could potentially work with the parameters in #1). (XXXX -> CA) (XYYX -> TX) https://help.tableau.com/current/pro/desktop/en-us/calcs_add_calculated_column.htm
m
Hi Kevin, Thank you for clarification. Regarding #1, I would like to be sure if you have the chance to check the Drilling options. And about #2, at first glance, it can not be done by MAQL as I mentioned, the 'output' always is a numeric value (metric), no string. But I will test further this option and provide an update, and if not, I would be happy to submit a product feedback on your behalf. Thank you for your patience.
j
SQL datasets can be used to create computed attributes in data model.
🙌 2
m
Hi Kevin, regarding the nice advice from Jakub, you can check further our documentation on how to create SQL Datasets.
k
@Mauricio Cabezas I'm going to take some time to fiddle with the Drilling options and come back to you with a more clearer example and questions if I still have any.