PodiumMason Contributor

Comments

  • Casting usually works fairly well for true Datetime columns. http://docs.aws.amazon.com/redshift/latest/dg/r_CAST_function.html Example: Cast("Datetime Column" as Date)
    in Redshift Date & Time to Date Syntax Comment by PodiumMason April 2017
  • Hi there! One way this can be accomplished is by using the beast mode functionality. You could create a beast mode titled for example: "Current Year New Business Summary". It might look something like this: SUM (Case when Year(`Date Column`) = Year(Current_date()) then `New Business Value Column` else 0 end) or if you had…
    in Filter Summary Number Comment by PodiumMason April 2017
  • Hi there! In the "edit card" screen, next to the card title, you should see a drop down displaying the current date range and granularity for your card. Simply click the drop down to open the date options menu (See screenshot), which will allow you to change the date granularity. (Use the "Graph By" option). Let me know if…
    in how do i change a date grain on a card Comment by PodiumMason April 2017
  • Hi there! It is possible to filter cards on a page on a separate dataset's result set if the column you'd like to fillter on is present in both datasets. For example: if I had two cards built on separate datasets that both contained the column "Store", I could apply a page level filter on the store column from either…
    in Filter Based on Another Report Comment by PodiumMason April 2017
Avatar