When I try using a United States map card or a State map card, I get the result in the screen shot I've attached. In this example, I've narrowed it down to 2 donors from Illinois (shown in the data table below the card). I am using the column "zip2fips.donor_state_tz" column for the "select county fips code" for US state…
I an trying to create a card that shows the top 3 reasons for termination based on the number of responses for each reason; I would also need it to show all other reasons when you drill down. The dataset has 2 columns: Reason for termination (10+ reasons), number of responses. Thank you in advance!
If my booking year = system year then cy else py not sure what was the error in beast mode..pls suggest CASE WHEN YEAR(`Booking Year Nbr`)= YEAR(CURDATE(),"CY" ELSE "PY" END
I am counting story points from a jira import, and while all the records are in the base data, when I create a pivot, it shows correct grand totals but skips some records, and fails to do row totals correctly. Even when I remove filters.
How to compare the data i have column like Fiscal Week so i wanted to compare each Qtr. trending by fiscal week comparison between Qtr with fiscal week trending pls suggest Column 1 column 2 FW 1 Q1 FW 2 Q1 FW 3 - 15 Q1 FW 16 Q2 FW 17 Q2 FW 18 Q2
I'm in the process of creating a series of Notecards with hyperlinks and an image in a Design Dashboard. After adding the links and the image to a card, the updates disappear after navigating away from the page. This has happened several times in a row - am I missing something or is there a known Notecard bug?
Is there a way write a formula that includes a field that doesn't contain a certain string? So for example, I'd like to name a value in a column based on other columns where if the event_name contains "Add-To-Cart" and the page_location doesn't contain "shop", then it'll be "Add to Cart from XXX"... when `EVENT_NAME` like…
I'm interested in creating a card that will show values from two different columns... For example, I have a table that includes two columns: -Sends -Delivered I'd like a card that has the sum of the Deliver column and also what percentage of the sends were delivered also in that card. i.e. 500 delivers and 75% delivery…
I've always struggled with figuring out how to filter by fields with nulls vs blanks... for example, if I have a formula to identify if a field is null (this will not work with fields that contain empty strings or blank values, correct...?). I've tried using charlength functions to say (when charlength' is greater than 0…
I have a database of millions of sales over time for a thousands of specific assets. I'd like to have a calculated field that determines the last 3 sales of an item. For some, they may have sold 3 times last month for others 3 times in the past 24 months. Thanks!!!!!
It looks like you're new here. Sign in or register to get started.