Month control selection

Q&A
, , , , , , ,
21

Hi @Srinath
as promised a step-by-step guide.

  1. I created a dataset with the sample data provided by @hellosai321 .
  2. Create a parameter called “DateFilterParameter” with type Datetime:
    image
    image582×526 21.7 KB
  3. Add the parameter to the sheet and change format to YYYY/MM.
  4. Create a “FilterField” to reduce the amount of tickets to the ones that are created or closed in the selected month from the parameter “DateFilterParameter”.
ifelse(
    (
        truncDate("YYYY",${DateFilterParameter}) = truncDate("YYYY",created) 
        AND 
        truncDate("MM",${DateFilterParameter}) = truncDate("MM",created)
    )
    OR 
    ( 
        truncDate("YYYY",${DateFilterParameter}) = truncDate("YYYY",closed) 
        AND 
        truncDate("MM",${DateFilterParameter}) = truncDate("MM",closed)
    )
    , "Y"
    , "N"
)
  1. Create a new field to count the number of created tickets “Created Tickets”:
ifelse(
    (
        truncDate("YYYY",${DateFilterParameter}) = truncDate("YYYY",{created}) 
        AND 
        truncDate("MM",${DateFilterParameter}) = truncDate("MM",{created})
    )
    , 1
    , 0
)
  1. do the previous step for closed tickets.
  2. Create the visualisation for the created tickets, grouped by the created date field and you new calculation:
    image
    image461×345 19.9 KB
  3. Create the second visualisation for the closed tickets (see previous step):
  4. Add two filters for the whole sheet:
    9.1 Filter all Dates with 0 created Tickets:
    image
    image238×644 18.1 KB

    9.2 Use the FilterField:
    image
    image231×743 21.7 KB

If you need more information please have a look into the analysis it self on Quick Sight Arena:
Ticket Analysis One Filter

Best regards,
Nico

22

Hi @hellosai321 ,

therefore you need two parameters, one for the start and one for the end of your range.
You have to change the calculation in that way, that it test if the date of the ticket in within the range of your parameters.
To show zeros for the month you can remove the filter for “Created Tickets” greater than 0.

Best regards,
Nico

23

Hi @Nico ,

Thank you and it is clear to me and also as I asked in my earlier post is there a way to show created,closed and backlog(Running open) together in a single bar chart as this is one of the ask from my customer?

Hi @hellosai321 - Can you please update here if you have a calculation built for single date range control as I tried but it is not working

Thanks,
Srinath