Forum Discussion

ChadSmith22's avatar
ChadSmith22
Frequent Visitor
4 years ago

Calendar value

Hi Everyone,   I have a report that i need to create. i have an excel file with a series of questions.   Example:   Question 1: Enter the duration of the challenge. User chooses two date field...
Need Help
ChadSmith22's avatar
ChadSmith22
Frequent Visitor
4 years ago

its not job related, ie not paid work i just want to build a heatmap by month to see the answers, its easier..

 

do you have any thoughts?

hnguy71's avatar
hnguy71
Super User
4 years ago

Hi ChadSmith22 ,

 

You would likely need to build two disconnected dimension tables, one for your dates and one for your choices. You'll also need to build fact table that captures the user inputs.

 

Honestly, it's a bit hard to visualize the requirement without understanding the full picture of the problem statement.

  • ChadSmith22's avatar
    ChadSmith22
    Frequent Visitor
    4 years ago

    • ChadSmith22's avatar
      ChadSmith22
      Frequent Visitor
      4 years ago

      Does the image help? i have a table in Power Called Questions. I do capture the title, start and end dates. But now i need to see at say Jan-22 am i green or amber based on all the questions..