Variables - list from a column


#1

Hi every one,

Once a week, I report the sum of my orders in my table.
In this table I have a column which represents the date that I report the orders.
I’d like to know if there’s a way to use a variable which display the list of dates that I report in this column

I’m using V0.31.2
Thanks in advance


#2

@Livier
I don’t understand. If you have the query or screenshot, then please post it - sometimes it’s easier to understand :slight_smile:


#3

This is a sample of my table
commande

I’d like to know if there’s a way to use a variable on date_de_relevee.
In my dashboard I’d like to have this :
liste

This variable would be use in a whare clause

Thanks :slight_smile:


#4

@Livier
Yes, you do that, but then you probably need to convert date_de_relevee to varchar and in Metabase set Field Type as Category. Or create another column, if you’re already using it for some date filtering, since date_de_relevee is effectively just a way for you to group the data by.