Forum Discussion
How to create slicer for dates and not affect other charts
My end goal is to have a table that will count the amount of closed cases/tickets within the last 24 hours and 30 days based off each tech.
columns: tech name | Closed last business day | Closed in last 30 days
John smith | 5 | 60
I was able to create a column with this:
Which works, and when I add them to a table, i select count and it gives me the total for the entire spreadsheet, I would like it to show me the last 24 hours and last 30 days
How woulod i be able to do this, would it be a measure or would can i use other filtering methods with date slicers?
Hi Anonymous
You can add a "Date Closed" column with only dates from "Date/Time Closed", and change this new column to Date type. You can also change "Date/Time Closed" column to Date type if you don't need its timestamp values later.
Then create the following measures with the date column. Put them in a table visual along with Tech name column.
Closed last business day = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] = TODAY()-1) + 0Closed in last 30 days = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] < TODAY(),'Table'[Date Closed] >= TODAY()-30) + 0Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
v-jingzhangCommunity Support
Hi Anonymous
You can add a "Date Closed" column with only dates from "Date/Time Closed", and change this new column to Date type. You can also change "Date/Time Closed" column to Date type if you don't need its timestamp values later.
Then create the following measures with the date column. Put them in a table visual along with Tech name column.
Closed last business day = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] = TODAY()-1) + 0Closed in last 30 days = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] < TODAY(),'Table'[Date Closed] >= TODAY()-30) + 0Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.