1 Reply Latest reply on Mar 4, 2016 3:53 PM by diego.medrano

    Customized billing trend

    Ganesh Vijay Kumar

      Hello Experts,

       

      I am pretty new to Tableau and Visualization tools. I am trying to create Visualization for Billings.

       

      I did search solution for below mentioned questions in tableau community. But however not completely successful.

       

      I have browsed another link to do these views, but could not understand the logic to apply for my scenario here(http://www.maassmedia.com/blog/tableau-tips-how-to-show-customized-monthly-weekly-and-daily-views-dynamically-in-your-dashboards/)

       

      I have billings data for the year 2015 ( Pvs Year) and 2016 ( Current Year) with columns :           

       

      “Customer Name”; “Fiscal Month”; “Fiscal Week”; “Fiscal Year”; “Fiscal Quarter” “Day of the week” and “Billing Amount”.

      My objective is see the customer “Billing Pattern”. Our fiscal year starts from October and ends in September and We follow 4-week, 5-week, and 4- Week pattern in a Fiscal quarter

       

      1)       My first visualization should be showing billings number only for 5 weeks. Now that we are in fiscal week 21 I would like to see data only for 17,18,19,20, and 21

       

      *The users should be able to look back 13 weeks data.

       

      Fiscal Week

      Billing Amount(Millions)

      17

      39.8

      18

      35.8

      19

      41.4

      20

      38.8

      21

      10.1

       

      2)       My second visualization should be showing billings number only for 5 weeks but by “Day of the Week” ( Our fiscal week starts from Saturday and ends on Friday)

       

      *The users should be able to look back 13 weeks data.

      Day

      Day Of the Week

      17

      18

      19

      20

      21

      1

      Sat

      875304.1

      875304.1

      814284.5

      2988776

      649997.5

      2

      Sun

      3273135

      3273135

      3063754

      3396655

      3376867

      3

      Mon

      9772693

      9772693

      11902777

      5853407

      6998569

      4

      Tue

      8687862

      8687862

      58322609

      12417382

       

      5

      Wed

      5462132

      5462132

      2306845

      4052974

       

      6

      Thu

      7861002

      7861002

      2540129

      7255770

       

      7

      Fri

      4058557

      4058557

      -4E+07

      6072448

       

       

       

      3)       My third visualization should be showing billings trend for last 12 months.

       

      4)       The final one would be on a Tuesday I would like to see Sum of (Mon + Tue), on a Wednesday would like to see sum of (Mon + Tue + Wed) by using the current year data.

       

      *The users should be able to look back 13 weeks data.

       

      Please help. Thanks a lot.!

       

      Thanks,

      Ganesh