JCB76 Member

Comments

  • I am having the same issue as Hua. Has there been any response? I can build the drill down cards and see the data while I'm editing the input values, but the cards are coming up blank when I drill down from the view. This is a dataset that I customized using an SQL dataflow to match the input values to the original dataset…
  • Godiepi! Thanks for the info - we were able to get around it by setting a time zone transfom on the job itself to EST. That way, the transform tells the workbench what time zone the data is coming in as, so it can translate to UTC for processing. Then, the company settings tell the workbench what time zone it needs to…
  • In the workbench, I have not specified a time zone for this dataset. Does it default to the timezone set on the computer? In Company Settings, it is set as America/New_York, which should also be EST, I believe. We actually are actually transacting in an EST time zone.
  • Thanks for the reply - I'd like to use the summation of the daily transactions to determine the average for a different timeframe i.e. weekly or monthly. So, if I want to see the data by day for 30 days, I would want to plot the summation of the daily inventories and use those to calculate the average over the month.…
  • Thanks for the reply! If I have the data grouped by days but need the daily summed quantity averaged over the population, how do I do that? Right now, when I bring in avg primary quantity, it is averaging the individual transactions - which I thought I wanted but it doesn't give me the trend line I was looking for.