Exploring & curating data
Dashboards, Looks, Visualizations— it all happens here
In order to show the chart with the order date “Jan 2018, Feb 2018, …, Dec 2018” on X-axis of the chart , I have hidden column with the value 2018-01, 2018-02, …, 2018-12 along side with the column “Jan 2018, Feb 2018, …, Dec 2018”, it works well, however once clicked the chart for the drill down, both columns are showed as filters at the top of the drill dow, for example: column-1: 2018-01, column-2: Jan 2018", how can I hide the column-1 to keep showing on the drill down.
I am trying to find the % change in every instance there has been a change to the List Margin on each unique ID. My data looks somewhat like this ID List Margin 1234 1200 1234 1200 1234 1250 1234 1250 1235 1500 1235 1500 1235 1575 1236 1600 1236 1600 1236 1600 1236 1650 I need a formula for the following: If the IDs are the same, then is there a difference in the List Margin from the row above (should yield YesNo). If there is a difference, then to calculate the % difference of the List Margin from that row to the row above.
Hi there, My goal is to have a measure, specifically an average, calculate across the entire underlying data set per row when I have pivoted columns. I can achieve this result if I check “Row Totals”. Additionally, I can do this with sum and pivot_row for number measures. However, I would like to add additional customization if needed so I need this in a table calc. Below is an example screenshot. Any thoughts?
I have a dataset in which I need to calculate the monthly average using the daily counts. So I need to include both the field for the date, and the month (I am not a developer so can’t change these options) So after a complicated calculation, I have yielded the right results, but I only want a to view monthly, but there are as many rows as are days. Is there any way to fix this visualization? The data set looks like this: The visualization is reflecting this: Rather than the number of rows equivalent to days, I just want 12 rows to display the months, if that makes sense. Any ideas?
Hey. I have a dashboard of the number of Salesforce cases tied to specific employees shown as a bar chart. The value labels along the axis are the employees names - is there a way to make these names bigger or are we stuck with the default format? Additionally, I would like to change the font color of the titles within tiles on a dashboard. By default they are gray on a white background and some of my coworkers have trouble reading them. Is there a way to do this?
Hey! Sorry if this is a n00b question… I’m just getting started with Dashboards and Reports. Is it possible to generate a series of charts at runtime (multiple charts, not multiple series in one chart)? I can generate the data as two queries (Query A gives me a list of ID’s, Query B is run multiple times with the ID as a filter - one chart for each ID) or as a single query (IDs and series data in one query, but the results would then be separated into a chart per ID)? A use case for this would be: We have 5000 stores. We want a dashboard or report that will show us a chart of the daily sales values for each of the top 20 stores by their most recent monthly total (a chart per store). Each month the set of stores would change, so we couldn’t use fixed criteria in 20 separate looks
I have a column chart, I would like to show the total, which on the data is easily provided by ticking the Row Totals box. But on the chart this column is obviously far larger than any of the other columns. I can easily change this to a line from a column by finding the Row Total in the series options of the chart. But I want it to obviously be on a separate Y Axis so it doesn’t dwarf the other columns. I think a lot of information I’m finding is a bit out of date, but in the options it looks like I can move the entire Series to a second Y Axis, but not the Row Totals individually. Is there an option I’m missing? At the moment I’ve got a line that tops out at 1300+ and columns that often barely hit 50, so they’re difficult to read
Actually, I am trying to create some table calculation but stuck at a point and its very very urgent for me, when i tried to save the formula then i can see the error message “Field “hr_spain_hotel_table_1.total_los_den” is not in the current query” as i am new in this so as per me i have checked all the steps but didn’t get any solution so please help me out to get it done ASAP and if possible then share the steps so that i can check it.
Hi, This is a typical Friday afternoon idea. I am trying to do a “random” segmentation on user id to create two groups and I would like to have all even user id’s in group 1 and the odd user id’s in group 2. Does anyone have a smart solution to do this? 🙂 Have a nice weekend. Best, Luc
Hi , Can looker support nested If condition in custom filters. for example , if I have several categories of data to be displayed and only three of them are considered and I need to display these three and rest can fall into ‘Others’ bucket . I do not have permissions to edit LookML/Custom SQL so have to do this in my “look”. something like : if(cat = “A”,“A”,(if (cat = “B”,“B”,if(cat = “C”,“C”,“Other”) ))
I would like to suggest how helpful a “grid background” on dashboards during “Edit Mode” would be for laying out tiles in a consistent way. This would make it easier to ensure that tiles are the same size and/or laid out on the same horizontal / vertical grid. Or perhaps there’s a suggestion for how to do this better as an end-user.
I have a table containing entity locations across the United States and I have a location filter that will allow me to find any entity within X miles from an a given point. I was hoping to create calculated fields which contain the distance and bearing from the location entered into the filter. Is this possible?
I have a dashboard containing 21 single tiles, and I’m trying to create a filter applying to 15 of them. Each has a separate table calculation, that can’t be avoided since columns are aggregates. When creating a new dashboard filter and selecting the tiles to update, I get the following error: The http code for error 413 is “entity too large”. Is there a way to avoid this, or is this a request for Looker backend to improve?
This is a bug and I have tried to submit a request through /hc/en-us/requests/new (from the help section on Looker) but it doesn’t seem to exist anymore. The gist of the problem is that download results via PNG will produce a truncated image of the results. Steps to reproduce: -From one of our tiles/widgets, we can filter results and view those in a modal: -When the modal pops up with table data, Download Results -Choose PNG (Image of Visualization) as the File Format, and Download (Or Open in Browser, both will produce the problem): https://www.screencast.com/t/CgoE7eNy -When the download is complete notice there are only 20ish lines of data showing, and most columns have also been truncated. Downloaded Results: https://screencast.com/t/GWElqU1lfk Just to make sure I have everything covered, here are the conversation points: Does the title sound interesting if you read it out loud? Is it a good summary? -Very clear title -Very clear summary Who would be interested in this? Why does it
Dual axes in Looker appear to be tied to each other, but I don’t think the should be. See this example. Why would I want the right axis go all the way up to 160%? Is that 160% coming from the max value of the left axis, 1.7? I want both axes to be pinned to 0. However, I think the left axis should go from 0 to 1.7 and the right axis should go from -8% to 0%.
Hi all ! I’m quite new on Looker and slowly getting a grasp on how it works. I’m trying to get a custom field which is an operation on a datetime (to which I’d add 18 hours, nothing crazy) in a string format. So basically I’m trying to cast this new datetime as a string. Any thoughts? I haven’t seen a data casting function yet. Thank you very much!
Hi, I am trying to create a bubble graph that has 1 dimension on the x-axis (tiered number of employees) and 1 dimension on the y-axis (tier number of seats for that subscription) and then the size of the bubble relates to the number of organisations that are observed. I seem to be running into issues with having a dimension on each axis. Is there a way around this? Oscar
Hi Everyone - I am trying to figure out how to create a visualization to show the number of active goals per user over time. Background: We are running a pilot for an app that allows users to create goals with a start date and end date. Question to answer: How many goals do people pursue at the same time? Desired Visualization: Number of active goals per active user over time. Note: If a user has not created any goals, or has completed all their goals, they don’t appear on that particular day. Ie, if a user has 0 active goals on a given day, we exclude them for that day’s calculations Let me upload a table and chart that maps out what I’m thinking for how to approach this. The open question in my mind is if I can graph only the subtotals for each time period, but not the data rows themselves.
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.