how to get Month Name from date field in quick sight?

IsLatestRecord = IF( 'vw_license_server_status'[update_date_utc] = CALCULATE( MAX('vw_license_server_status'[update_date_utc]), ALLEXCEPT('vw_license_server_status', 'vw_license_server_status'[server_name],vw_license_server_status[server_status], vw_license_server_status[license_manager_type]) ), 1, 0 ) i want to convert this power bi dax to calculated field in quicksight how to do it

how do you do it in a line chart with drill down to week (so change from ending balance for the month to ending balance for the week)? is it even possible?

Well done thanks

Thank you so much for your tutorial. It is very helpful for beginners to learn about visual data projects in QS!

Can you please explain how to create calculated fields for this financial year and last financial year in Quick-sight?

awesome tutorial 👍

audio quality is bad - its fading in and out

Thank you for creating such a detailed video.

In metric to display calculation field, Is total cases per million automatically suggested?

Thank you!

As someone who is primarily a Tableau user, this was incredibly helpful, informative and easy to follow. A fantastic way to practice all these skills - thank you both!

Please help me to find this dataset

Thanks for this Video! As a Tableau user primarily, noticed a lot of nice similarities here!

Is there any way to get only Months in the X axis of the line chart? Please reply.

How to create a line chart with only month names on the x axis? And need to sort them in ascending order like January Feb march etc.

can we hide tabs but use them when we try to navigate from one tab to another ?

can i add multiple filter in this ?

I want to pass datefield in parameter how can i do that Or can i make a string and inside that directly pass datefield there for example I am working here from {datefield} like this , Is it possible !!!!!!!!!!

what is the formula inside that Country with dash?

You explained calculated fields much better that all the videos I’ve watched

I have done the same thing but it is not working properly for incognito windows. Any solution for that?

Best tutorial on QS. Great job and thank you!

Thanks for the tip!

Looks like AWS serviced for Big Data and Analytics

Great vid

Hi Karel, I created Date Granularity using calculated field(ifelse( ${FullDateGranularity}='Day',truncDate("DD",{survey_date}), ${FullDateGranularity}='Week',truncDate("WK",{survey_date}), ${FullDateGranularity}='Month',truncDate("MM",{survey_date}), ${FullDateGranularity}='Quarter',truncDate("Q",{survey_date}), truncDate("YYYY",{survey_date}) )). Pin the control to top, but when I select a monthly granularity within a certain timeframe (like from 4th of April to the end of the year) my pivot table shows me yearly granularity. Would you know what could be possibly an issue there? Thank you very much!

sadly, the forward periods is manual set by how many days we need. it's not an date filter

the resources are free to load？

Please, I need the data sheet from the Excel program

Hey, I want to forecast coming week volume based on average of previous weeks, can we do this using forecast ?

my latitude and longitude are not being recognized as geocodes hence i cant plot it on map, do you have any idea how to resolve that?

Thank you for the video. I could not select the "what if" target because my right click did not work, it opened the browser's tools instead of the video's menu. Did anyone have the same issue?

one questions ? is necessary has credit card for use postgres database aws?

beautifully explain great job.... thank you so much I had a data analyst interview the company give me a task to make a dashboard and this video helped me a lot

Thanks so much

thank you, you saved my life.

Thank you for making these videos. They helped improve how I present dashboards

How can I hide blank rows in quicksight i don't want to filter them out..? We have option to hide columns but not rows.

I have watched this twice and it is a great tutorial on Quicksight. Thank you!

shame on you

What a great , clear, video but unfortunately my Readers can still see other people's data. I have 20 stores . Each should only be able to see graphs derived from their store's data. In the main csv I have col called UserName, in the filtering CSV I have col called UserName, and this UserName matches the the username of the of the reader I created in QS>Manage. In QS > Datasets , there is a lock icon next to the data. But when I log in as that UserName , my plot shows all of the stores data. Any idea what some of my mistakes might be?

Thanks for this effort. Highly informative

Having used Quicksight for over a year now, I have to say that it is very, very difficult and complicated. It is very slow and the simplest thing requires hours of preparation. It is a very poor platform for analyzing the data. I recommend Zoho Analytics.

Very informative tutorial. Covered most of the functionality of Quicksight. Thanks a lot :)

Great Video!

Hey, can you provide the name and link for the CSV file to be used for the dashboard? I cannot find the particular data to be used

hi, great reasoning. I too had a question, I need to append 2 different data sources, first, sales data of tier 1 cities from SQL database & and sales data of tier 2,3 cities from Excel. Doing “add data” only gets me to join other datasets but I am unable to find a way to append data sources. Columns & data types are identical in both data sources.

great explanation!

Very useful, thanks a lot for sharing.