Hello community!
Is it posible to concatenate different dates from different columns and then create an interactive dashboard where I could select from Ref tables the year, month and day and if in the filtering conditions from the ref tables are = to some of the concatenation dates show the data in a view?
Can you walk us through an example?
Sure.
I had a table with 31 columns, each column for each day of the month. When the user trigger an action, the cell of the column corresponding to the date of today (eg: [col24] data cell = 24/09/2019 10:46:34)is filled by date and hour.
Si I need at the end of the month I want to look at what happends in a particular day of the month this filter can show me the data for that day of all the rows that are equal at the filtering condition
What you want may be possible, but only with a great deal of complicated configuration that Iām not going to bother exploring. Your goal would be a lot easier if you restructured your daily data as rows rather than columns.