Generating Heatmaps

  • Posts: 13
  • Thank you received: 0

Generating Heatmaps was created by Jim

I have a raw file that with several attributes and I wanted to generate in week over week and Month over month.

Date attribute1 attribute2 attribute3 attribute3
1/1/16 pass pass pass fail
1/1/16 fail fail fail fail
1/1/16 pass pass pass pass
1/1/16 fail pass fail fail
1/2/16 pass pass fail pass
1/2/16 pass pass fail fail
1/2/16 fail pass fail fail
1/3/16 fail fail fail fail
1/3/16 fail fail fail fail

The following result should be generated

Date attribute1 attribute2 attribute3 attribute3
1/1/16 50% 25% 50% 75%
1/2/16 33% 0% 100% 66%
1/3/16 100% 100% 100% 100%
4 years 7 months ago #14612

Please Log in or Create an account to join the conversation.

  • Posts: 87
  • Karma: 9
  • Thank you received: 15

Replied by KevinJohn on topic Generating Heatmaps

Hi Jim,

We can use the PIVOT TRANSFORMATION to achieve your goals. Pivot transformation object can output data with a single row according to defined date duration.

The following document should help you further: Working with Pivot
4 years 7 months ago #14613

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies