0

Need Help Formatting Table to Show Data (by Date) in Multiple Columns from Same Data Source

Hey All! Could really use some help. I added a simple screencap to help explain. 

I am comfortable enough in Klipfolio to format a table and then add hidden data to sort by date. 

But, I need multiple columns of data by date. This makes using hidden data for the whole table ineffective. 

What's the best way for me to accomplish what I am looking to do here?

 

1 comment

  • Avatar
    Parker Selman Official comment

    Hi Michael, 

    Thanks for your question! 

    You're correct in that hidden data filters apply to the entire table, so you'll need to use the column formulas to filter for the correct month. 

    To do this, you can format each of your January and February columns with an IF statement that will align the data accordingly. In your case, this could be something like:

    IF(DATE_CONVERT(@Date,"MMM-yy","MMM")="Jan",@Sales,BLANK())

    With "Jan" swapped out for "Feb" in the next column. This formula will only return the sales data for the month specified, but will also retain alignment with your Product column, ensuring it displays correctly in your Klip. 

    Hope this helps! If you have any further questions, please submit a ticket with our team and we'll be happy to answer any questions. 

    Parker

Please sign in to leave a comment.