how to utilize multiple date columns that has values for showing the trend

art_in_sky
art_in_sky Member
edited March 26 in Beast Mode

I have dates for each month for a total of twelve months ( 12 columns), each column has a value under it for every chapter. Now i want to utilize the chapter , the twelve columns to showcase a graph that has trend for year to date. How do I achieve this?

Tagged:

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @art_in_sky I'd suggest using the Unpivot Tile in MagicETL to restructure your data into 3 columns: Chapter, Date/Month, and value. Then you can create a card with Date/Month as your dimension, Value as your measure, and Value as your metric.

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @art_in_sky I'd suggest using the Unpivot Tile in MagicETL to restructure your data into 3 columns: Chapter, Date/Month, and value. Then you can create a card with Date/Month as your dimension, Value as your measure, and Value as your metric.


  • Thank you so much. I was able to create a dynamic unpivot, keeping in mind the future addition of date columns.