How to create a dataset based on another dataset

ecabanas

Hi everyone,

I would like to create a calendar table based on an orders data base, based on min and max date from that.

Do you know a way to do it?

Thanks for your help

Eduard

jessdoe

What is your exact formula and what error did you receive?

If date_column is order date, then you can just use order_date in all of your transforms - you don't need to create a separate table. If the date_column is from a different table, please past your formula + error

jessdoe

Using your orders table, you can create a date table via a case statement like

case when date_column >= min(order_date) and date_column < = max(order_date) then date_column

Also highly recommend checking out the domo dimensions calendar table in the app store to see if that meets your need.

ColemenWilson

You would use magic ETL. Use the group by tile and create max and min values. You could also use the formula tile and use MAX() and MIN(). You could also use a beastmode in a card and use MAX() and MIN().

There is also a calendar chart type. This knowledge article walks through how to use them: https://domo-support.domo.com/s/article/360043427973?language=en_US

ecabanas

https://community-forums.domo.com/main/discussion/comment/82458#Comment_82458

Hi
Thanks for your help, but I did a statement in sql transform but did not work

case when date_column >= min(order_date) and date_column < = max(order_date) then date_column end

I don't know what I'0m doing wrong

thanksssss

jessdoe

What is your exact formula and what error did you receive?

If date_column is order date, then you can just use order_date in all of your transforms - you don't need to create a separate table. If the date_column is from a different table, please past your formula + error