-
Filtering a set of rows by event time (across different time zones)
I have a dataset, for example, with 3 events in each of the US time zones -- all coming through as 7pm local to the time zone in the dataset. I need to sort them by the time occurring, so in the example below, California events would be listed first, then Colorado, then Chicago, then New York. How can i do this? Can I do…
-
Combining outputs from 4 different cards and 4 datasets I don't want to join together
Hello, Hoping there's an easy answer to this. I have 4 different cards coming from 4 different datasets with no common fields. So I don't want to join them together. The 4 cards created are 1 number cards showing a dollar calculation (let's call it "profit"). Card #1: Profit from Sales ($100) Card #2: Profit from…
-
Help graphing a calculated field that sums up two data columns
I have a dataset that has daily data spanning back to the beginning of 2019. Let's call column A "Sales Date" Let's call column B "Daily Sales" Let's call column C "Employee Name" I then am creating a beast mode calculation for "Month" and "Year". I want to be able to plot in a bar graph the calculation, by month/year, the…
