Beast Mode

Beast Mode

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

Contributor
edited March 2024 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

  • 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

  • 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.

  • Contributor


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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In